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

12 votes97 views4 answers
Mysql get date difference in hours
SQL
0 vote101 views1 answer
Search column name sql
SQL
0 vote101 views1 answer
Power bi dax add related shows column but not working
SQL
6 votes100 views5 answers
Mysql get last insert id
SQL
1 vote109 views1 answer
Mysql count multiple columns in one query
SQL
1 vote105 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote109 views1 answer
Psql list view rules
SQL
0 vote107 views1 answer
Set a value by excuting stored procedure
SQL
0 vote111 views2 answers
Drop tables from local table database postgres
SQL
0 vote148 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL