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

17 votes194 views6 answers
Mysql import sql file
SQL
0 vote217 views1 answer
Postgres - Login and connect as default user
SQL
3 votes192 views2 answers
Pl sql escape '
SQL
1 vote186 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
4 votes189 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote201 views1 answer
Alter column to not null with default value sql server
SQL
11 votes190 views2 answers
Safe mode off mysql
SQL
0 vote199 views1 answer
SQL Server Enterprise
SQL
0 vote201 views1 answer
Excel export from sql using python
SQL
2 votes207 views2 answers
Mysql count rows returned
SQL