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

1 vote396 views1 answer
How to set up a trigger in sql
SQL
4 votes369 views2 answers
Oracle drop job
SQL
0 vote339 views1 answer
Exec procedure oracle
SQL
3 votes362 views2 answers
@sqlresultsetmapping
SQL
0 vote351 views1 answer
How to find table lock and row lock in mysql
SQL
3 votes338 views3 answers
C# sql select
SQL
0 vote332 views1 answer
Sql grant select only
SQL
0 vote343 views1 answer
How to add timestamp column in mysql
SQL
-1 vote330 views3 answers
Create temp table in sql
SQL
10 votes439 views4 answers
Sql server pagination
SQL