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

6 votes121 views3 answers
Rename column ORACLE
SQL
93 votes101 views4 answers
Create database postgres
SQL
0 vote108 views1 answer
Doesn't have default value mysql
SQL
1 vote122 views1 answer
Sql query row number group by
SQL
0 vote125 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote116 views1 answer
Greater than or equal to symbol in postgres
SQL
6 votes134 views2 answers
Mysqldump password in file
SQL
3 votes117 views3 answers
List columns in table postgres
SQL
12 votes122 views4 answers
Import mysql database command line linux
SQL
0 vote126 views1 answer
Sql query to get contact form 7 fields
SQL