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 vote151 views1 answer
Stop psql server windows
SQL
1 vote119 views1 answer
Order by oracle
SQL
2 votes84 views1 answer
Sql group by different columns
SQL
-1 vote144 views1 answer
Sql show custom constraints
SQL
0 vote119 views1 answer
Mysql undo delete
SQL
0 vote132 views1 answer
Get from database the most recent data limit by 5
SQL
1 vote144 views1 answer
Sql query row number group by
SQL
-1 vote130 views2 answers
Full join sql
SQL
0 vote120 views1 answer
Mysql Error Code: 1005
SQL
2 votes111 views1 answer
Oracle sql drop column if exists
SQL