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 vote207 views1 answer
Sql examples from framework
SQL
0 vote221 views1 answer
Returning with sqlalchemy
SQL
1 vote285 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
5 votes294 views1 answer
Oracle source query
SQL
0 vote294 views3 answers
Get count of null in column sql
SQL
0 vote146 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
3 votes229 views1 answer
How to add unique constraint in mysql table
SQL
1 vote188 views1 answer
Get url of cpanel database hostname
SQL
0 vote204 views1 answer
How to get one year old query from plan cache
SQL
3 votes255 views2 answers
Wp do sql query from function
SQL