CREATE OR REPLACE FUNCTION

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

Source: tutorialspoint.com

CREATE OR REPLACE FUNCTION

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

Source: tutorialspoint.com

Similar codes

0 vote306 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote176 views1 answer
Multiple left join mysql
SQL
0 vote214 views1 answer
Mysql show schema
SQL
0 vote175 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote178 views1 answer
Declarative base sqlalchemy
SQL
0 vote175 views1 answer
Sql find all different values in column
SQL
5 votes173 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote210 views1 answer
Sql describe
SQL
0 vote234 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote180 views1 answer
Sqlalchemy one column of two has to be not null
SQL