Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Returning a record set with a stored procedure
Thomas,
Maybe someone should just write a little program that posts this answer
daily.
Naw, it would still get asked.
Keep up the outstanding work.
Jim
"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
news:9th7fd077j_at_drn.newsguy.com...
> In article <5a6ed0d7.0111210517.666e056f_at_posting.google.com>,
> rmctyre_at_hotmail.com says...
> >
> >I would like to create a simple stored procedure that consists of a
> >single SELECT statement. Can you do this with Oracle? If so, can
> >someone give me a hint on the syntax?
> >
> >Example:
> >
> >Table_A
> >-------
> >ProductId
> >ProductDescription
> >
> >SELECT ProductId, ProductDescription
> >FROM Table_A
>
> read
> http://osi.oracle.com/~tkyte/ResultSets/index.html
>
> ...
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Wed Nov 21 2001 - 16:39:01 CST