OraFAQ Forum: SQL & PL/SQL » Deafult Parameter

Home » SQL & PL/SQL » SQL & PL/SQL » Deafult Parameter

Thu, 28 February 2002 06:41

Panneer Selvam
Messages: 7
Registered: November 2001

Junior Member

How to declare a default input parameter in a function

Thu, 28 February 2002 07:02

Jon
Messages: 483
Registered: May 2001

Senior Member

Like this

create or replace function my_square (i_number IN NUMBER := 1)
return number
is
begin
return(i_number*i_number);
end;

Previous Topic:	not a single group function
Next Topic:	Table Name as Parameter in Function

Goto Forum:

]

Current Time: Fri Apr 19 00:12:04 CDT 2024