Re: User Functions

Do I need to have any special accesses to define the function?

Do I need to define the function only once, or should I always include it each time I execute the query?

Thanks

srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0203122335.44ae6340_at_posting.google.com>...
> 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 Thu Mar 14 2002 - 00:01:12 CET