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

8 votes302 views2 answers
Update sql server from another table
SQL
5 votes267 views1 answer
Oracle ora-00054 resource busy
SQL
1 vote288 views2 answers
Sql server backup table
SQL
14 votes280 views2 answers
Install mysqldump
SQL
0 vote270 views1 answer
Mysql undo delete
SQL
1 vote283 views2 answers
Postgres select from last 3 months
SQL
0 vote275 views2 answers
Search stored procedures
SQL
0 vote343 views1 answer
Php insert null mysql
SQL
0 vote258 views1 answer
Sql find leading space
SQL
1 vote258 views1 answer
Oracle update with sequence
SQL