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 vote172 views1 answer
Postgres select except
SQL
0 vote183 views1 answer
Sql max min
SQL
0 vote289 views1 answer
Postgres list all stored procedures query
SQL
0 vote183 views1 answer
Write sql query to show the details start from digit
SQL
0 vote179 views1 answer
Drop a field in psql django
SQL
0 vote203 views10 answers
Sql statement checker corrector
SQL
0 vote186 views1 answer
Replace content value from old to new sql
SQL
6 votes193 views1 answer
Allsource oracle
SQL
0 vote172 views1 answer
Sql constarint
SQL
1 vote177 views1 answer
Search for replace in mysql
SQL