Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Function to do This?

Re: Function to do This?

From: Stan <delphidev_at_yahoo.com>
Date: Fri, 09 Apr 1999 08:22:15 -0400
Message-ID: <370DF0F7.60BF329D@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US