Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: returning three select statements from a function
You could proabbly concatenate the results for all three selects into a big varchar2 variable and add CHR(10) (or 12) linefeeds and then return a single formatted (w/ linefeeds) varchar2 at the function output. Just a guess.
"SP" <spant1_at_aol.com> wrote in message
news:uYA15.1321$Qf6.51350_at_nuq-read.news.verio.net...
> I want to return the output from three diiferent select statements (by a
> function) like this:
> name date issueNumber
> ----- ---------- ----------- -------
> (0 row(s) affected)
>
> r_date prodID
> ---------- ----------- -------
> (0 row(s) affected)
>
> date issueNumber
> ---------- -----------
> (0 row(s) affected)
>
> I was using ref cursor to return a single select statement. Is it
possible
> to return all three from a single function. I would appreciate your
input.
>
> SP
>
>
>
Received on Tue Jun 13 2000 - 00:00:00 CDT