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 vote255 views1 answer
How to find username and password in oracle 18c
SQL
0 vote257 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
3 votes271 views2 answers
Postgres inner join vs join
SQL
25 votes272 views5 answers
Date in mysql
SQL
2 votes271 views1 answer
Sql update \
SQL
2 votes291 views3 answers
Row number mysql
SQL
0 vote257 views1 answer
Create database like
SQL
0 vote281 views1 answer
Mysql a from on this page has
SQL
44 votes348 views4 answers
Mysql alter table add column first
SQL
1 vote256 views3 answers
Union SQL
SQL