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 vote130 views1 answer
VSCode SQL Server Connection error
SQL
0 vote207 views1 answer
Alter table name including schema
SQL
62 votes201 views8 answers
Mysql add column
SQL
9 votes133 views4 answers
Add primary key to existing table sql
SQL
1 vote142 views3 answers
How to reset id column in sql server
SQL
0 vote161 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote122 views1 answer
Count the table indatabase
SQL
3 votes136 views2 answers
Sql asc
SQL
0 vote148 views1 answer
Install squirrel sql ubuntu
SQL
1 vote147 views1 answer
Default
SQL