Re: User Functions

create or replace function myuserfunction (x in number, y in number) is
begin

/* blah blah blah */
return(x-y);
end;

"Nick Tompson" <ntompson_at_utas.edu.au> wrote in message news:7ae6b4ef.0203121907.44e7571f_at_posting.google.com...
> I understand that Oracle SQL allows user functions to be defined. Can
> anyone help me with how to get started/references on doing this.
>
> The function that I want to define is reasonably simple, it would take
> two numerical values, perform a calculation or two, then return a
> numerical result.
>
> I would want to be able to use the function in a normal SELECT query,
> something along the lines:
>
> SELECT
> x,
> y,
> myUserFunction(x,y)
> FROM aTable;
>
> Help! Please!
Received on Wed Mar 13 2002 - 05:14:19 CET