Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Function to do This?
But I would still need to program each function. Correct?
Stan.
Vitaliy Mogilevskiy wrote:
> DelphiDev wrote:
>
> >
> > Some examples of calls:
> > LookUp('JOBS','VP','JOBDESC'); --Returns "Vice President"
> > LookUp('CITIES','CA'+'SF','ZIPCODE') --Returns ZipCode for S.F. CA
> > (Note, CITIES primary key is "STATECODE+CITYCODE");
>
> Oracle allows you to overload functions and procedures in packages,
> you can use that to develop set of functions which share same name but
> take different parameters and Oracle will figure out which function to use
> based on the parameters you pass to the <PACKAGE>.<FUNCTION_NAME>
>
> --
> +--------------------------------------------------------------------------+
>
> | Vitaliy Mogilevskiy
> | Senior Consultant
> | CORE Technology Group, Inc.
> | E-mail: vit100gain_at_earthlink.net
> | Web Page: http://home.earthlink.net/~vit100gain/index.html
> | *** Free DBA Script Library at my Web Page ***
> +--------------------------------------------------------------------------+
Received on Fri Apr 09 1999 - 07:22:15 CDT
![]() |
![]() |