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 vote214 views1 answer
Mysql faster delete
SQL
0 vote171 views1 answer
Oracle exchange subpartition
SQL
0 vote163 views1 answer
Mysql regex exact match
SQL
0 vote187 views1 answer
Sql alter table order by
SQL
2 votes172 views1 answer
Sqlite indexes
SQL
0 vote182 views1 answer
Sql server user permissions and roles
SQL
0 vote201 views2 answers
Insert data mysql with cmd
SQL
0 vote177 views1 answer
Oserror mysql_config not found virtualenv
SQL
3 votes190 views1 answer
Sql print all names that start with a given letter
SQL
0 vote164 views1 answer
Sql right characters
SQL