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 vote326 views1 answer
Update view sql
SQL
4 votes317 views3 answers
Oracle sql first day of quarter
SQL
42 votes434 views6 answers
Rename table sql server
SQL
0 vote321 views1 answer
Sql server port 1434
SQL
0 vote333 views1 answer
Frename oracle
SQL
-1 vote354 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
-1 vote316 views3 answers
Update mongodb version ubuntu
SQL
2 votes318 views1 answer
Drop table purge
SQL
0 vote451 views5 answers
Right join
SQL
0 vote338 views1 answer
Flexible search query delete table
SQL