Re: how to make function to return multiple fields??

From: Jeff Chirco <jchirco_at_adelphia.net>
Date: Thu, 12 May 2005 21:31:27 -0700
Message-ID: <gqmdneAQmeUMsBnfRVn-iA_at_adelphia.com>


Yeah that link was already posted in this topic. I checked it out but I still don't understand. Sorry I am a newbie. I'm dumb.

"Maxim Demenko" <mdemenko_at_gmail.com> wrote in message news:d5tsi5$bdh$04$1_at_news.t-online.com...
> jeffchirco_at_gmail.com schrieb:
> > Is there a way for a function to return multiple columns and multiple
> > rows
> >
> > For simplicity, say I have a table EMPLOYEE like below;
> >
> > dbid dbfname dblname
> > 1 Jeff Chirco
> > 2 Dave Quackenbush
> > 3 Warren Fitzgerald
> > 4 Josh Freeze
> > 5 Joe Escalante
> >
> > And I want my function to return all the contents of this table. How
> > would I do this? Is it possible?
> > My real function accepts a bunch of paremeters and does a lot of others
> > things to get the results I want.
> >
>
> Have a look here:
>
http://groups.google.de/group/comp.databases.oracle.misc/browse_frm/thread/1 a80c1791c9eb1cf/1d51113ec5b7f773?hl=de#1d51113ec5b7f773
>
> Best Regards
>
> Maxim
Received on Fri May 13 2005 - 06:31:27 CEST

Original text of this message