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

31 votes332 views2 answers
Grant all priviledges to mysql user
SQL
1 vote304 views1 answer
Show table columns
SQL
2 votes307 views1 answer
Postgresql drop primary key constraint
SQL
1 vote316 views1 answer
How do you use sql in you company
SQL
-1 vote369 views4 answers
Full outer join in sql
SQL
0 vote300 views1 answer
First mysql
SQL
0 vote315 views1 answer
Mysql workbench view
SQL
0 vote344 views1 answer
Reset postgres table index to next max value
SQL
0 vote319 views2 answers
Dbms interview questions
SQL
0 vote335 views1 answer
Postegresql update to null
SQL