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 vote183 views1 answer
Sql composite key
SQL
1 vote196 views2 answers
How to check if sql query is correct online
SQL
5 votes237 views1 answer
Mysql created at yesterdau
SQL
0 vote194 views1 answer
Postgresql delete limit
SQL
0 vote197 views1 answer
Oracle service name view
SQL
0 vote191 views1 answer
Python mysql show databases
SQL
12 votes213 views6 answers
Change mysql root password
SQL
0 vote185 views1 answer
How to reset table in sql server
SQL
20 votes198 views6 answers
Change password in mysql
SQL
0 vote192 views1 answer
Mssql current date
SQL