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

7 votes258 views1 answer
Grant schema permissions postgres
SQL
0 vote253 views1 answer
Sql random decimal
SQL
0 vote296 views2 answers
Pop sql insert value into
SQL
0 vote297 views1 answer
Select sql in descending order
SQL
0 vote305 views1 answer
Move table to a different schema
SQL
0 vote272 views1 answer
Heidisql check how much space a row
SQL
0 vote289 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote262 views1 answer
Oracle search in date columns
SQL
0 vote299 views1 answer
How to install sql in anaconda
SQL
0 vote274 views1 answer
T sql check active deadlock
SQL