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

0 vote131 views1 answer
Sql column as header
SQL
0 vote184 views1 answer
Oracle db get table sizes
SQL
0 vote129 views1 answer
How to start my sql server on mac
SQL
0 vote127 views1 answer
Mysql search multiple tables
SQL
1 vote151 views1 answer
Mysql connect command
SQL
0 vote130 views1 answer
Calculate age in sql
SQL
1 vote145 views1 answer
Sample clause in sql
SQL
0 vote161 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote135 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote169 views1 answer
How to get table current identity value in sql server
SQL