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

1 vote155 views1 answer
Scaffold mysql database
SQL
0 vote220 views1 answer
Postgres extract number from string
SQL
5 votes170 views3 answers
Sql max value in column
SQL
25 votes164 views1 answer
Mysql grant all privileges to a user
SQL
4 votes170 views1 answer
Update table from another table oracle
SQL
0 vote169 views1 answer
Run postgresql dump to csv
SQL
0 vote177 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote157 views1 answer
Find largest table in mysql database
SQL
1 vote161 views1 answer
What is int in mysql
SQL
10 votes165 views5 answers
Create table mysql query
SQL