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

5 votes339 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
9 votes340 views6 answers
Check constraint in sql
SQL
0 vote334 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote364 views1 answer
How to connect to xampp sql server on windows cmd
SQL
14 votes386 views6 answers
Finding duplicate rows mysql
SQL
0 vote374 views2 answers
How to truncate all table in mysql workbench
SQL
2 votes340 views1 answer
Codeigniter print last sql query
SQL
7 votes333 views6 answers
Group_concat in mysql
SQL
6 votes322 views3 answers
Mysql first day of year
SQL
0 vote344 views1 answer
Php mysqli install
SQL