Creating A Function In SQL

CREATE [OR REPLACE]  FUNCTION function_name
[(parameter_name [IN | OUT | IN OUT] type [, ...])]
RETURN return_datatype
{IS | AS}
BEGIN
   < function_body >
END [function_name];

CREATE OR  REPLACE  FUNCTION Total
RETURN number IS
   total number(2) := 0;
BEGIN
   SELECT count(*) into total
   FROM TotalEX;
   
   RETURN total;
END;