Re: User Functions

example
CREATE OR REPLACE FUNCTION my_sum(p_a number,p_b number) RETURN NUMBER as
begin
 return p_a + p_b;
end;

then use the function in a select statement SELECT a,b,my_sum(a,b)
  FROM x;

The function that you create has to have certain purity levels depending on the clause in which you want to use it. There are 4 purity levels.
RNDS,RNPS,WNDS,WNPS.
see Oracle Doc (Application Developers Guide) for more details on the purity levels.
srivenu Received on Wed Mar 13 2002 - 08:35:19 CET