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

3 votes276 views3 answers
List columns in table postgres
SQL
1 vote202 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote206 views1 answer
How to check even or odd in sql
SQL
0 vote243 views1 answer
Combine 2 columns search query mysql
SQL
0 vote208 views1 answer
How to select a row in sql
SQL
0 vote277 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote194 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote201 views1 answer
Wordpress sql change site url
SQL
1 vote246 views1 answer
Create sqlite database in laravel
SQL
4 votes190 views1 answer
Postgresql show current database
SQL