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

15 votes101 views4 answers
Export mysql db using command line
SQL
0 vote99 views1 answer
List all permissions on a table in postgres
SQL
3 votes99 views1 answer
Postgresql cast
SQL
0 vote105 views1 answer
Mysql workbench procedure
SQL
0 vote94 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote106 views2 answers
Snowflake alter column data type
SQL
2 votes147 views1 answer
Oracle list grants on package
SQL
0 vote114 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote61 views3 answers
Mysql calculate age from date of birth
SQL
3 votes88 views1 answer
Sql timestamp to date
SQL