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

2 votes95 views1 answer
Oracle sql drop column if exists
SQL
0 vote113 views3 answers
Query string not ending with with vowels
SQL
1 vote105 views2 answers
Install mysqldump ubuntu
SQL
21 votes107 views6 answers
Docker run mysql
SQL
2 votes128 views1 answer
Oracle trace file
SQL
0 vote105 views1 answer
Mysql command line ubuntu
SQL
0 vote135 views1 answer
Table user postgres
SQL
1 vote109 views1 answer
ORA-01950
SQL
1 vote113 views1 answer
Ef core 5.0 usesqlserver not found
SQL
13 votes111 views3 answers
Sql online code
SQL