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

46 votes221 views4 answers
Create column sql
SQL
6 votes158 views3 answers
Sql select last id
SQL
0 vote145 views1 answer
Sql where time stamp is in between
SQL
0 vote144 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
-1 vote152 views3 answers
Psql get last rows
SQL
0 vote141 views1 answer
Sql select most frequent value in group
SQL
16 votes142 views1 answer
Mysql mediumint max value
SQL
0 vote155 views1 answer
Import mysql'
SQL
2 votes170 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote186 views1 answer
Sqlite trim
SQL