Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Returning a record set with a stored procedure

Re: Returning a record set with a stored procedure

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 21 Nov 2001 22:39:01 GMT
Message-ID: <92WK7.55025$XJ4.32828050@news1.sttln1.wa.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US