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

1 vote173 views1 answer
Import mysql dump database command line linux
SQL
8 votes160 views1 answer
Sql remove leading spaces
SQL
0 vote156 views1 answer
Sql auto_increment syntax
SQL
0 vote110 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote153 views1 answer
How to increase the width of the screen in oracle
SQL
-1 vote149 views1 answer
Ssms connect with connection string
SQL
18 votes157 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote151 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote157 views1 answer
Mysql beautifier terminla
SQL
4 votes144 views1 answer
Oracle session date format
SQL