Re: Function to do This?

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 ***
+--------------------------------------------------------------------------+