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 vote239 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
6 votes225 views1 answer
Sqlite foreign key
SQL
0 vote219 views1 answer
Hibernate with springboot mysql
SQL
0 vote259 views1 answer
SQL joins in python
SQL
3 votes245 views1 answer
Null sql
SQL
6 votes241 views1 answer
Oracle rank
SQL
0 vote203 views1 answer
Big query add table rows to another table
SQL
0 vote232 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
3 votes253 views1 answer
Increment integer in table sql
SQL
5 votes213 views2 answers
Create table
SQL