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 votes174 views2 answers
Mysql time
SQL
0 vote150 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote184 views1 answer
Offset in postgresql example
SQL
2 votes182 views2 answers
Postgres add column integer
SQL
11 votes177 views2 answers
How to import mysql database command line
SQL
-1 vote136 views1 answer
Oracle db list usernames
SQL
1 vote167 views2 answers
Logical operators in sql
SQL
0 vote167 views1 answer
Sql case when exists in another table
SQL
3 votes173 views1 answer
Two select sql
SQL
1 vote184 views1 answer
Trigger in postgresql to change incoming entry
SQL