Re: how to make function to return multiple fields??
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 11 May 2005 23:13:46 +0200
Message-ID: <d5tsi5$bdh$04$1_at_news.t-online.com>
Date: Wed, 11 May 2005 23:13:46 +0200
Message-ID: <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/1a80c1791c9eb1cf/1d51113ec5b7f773?hl=de#1d51113ec5b7f773
Best Regards
Maxim Received on Wed May 11 2005 - 23:13:46 CEST