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 -> How do I do a simple select in a stored procedure

How do I do a simple select in a stored procedure

From: GB <fatboyrider_at_hotmail.com>
Date: 23 Apr 2002 06:23:55 -0700
Message-ID: <600c339e.0204230523.7303050d@posting.google.com>


I am a user of Visual Basic / SQL Server and have found myself responsible for doing a conversion to Oracle. In a stored procedure, it seems that a simple select of multiple rows (Select * from MyTable) from a table has to be done in a different way. Using in-line SQL from my VB program works fine of course. I have gathered that I need to use a cursor, my question is what syntax do I use to return the individual rows as if I just used in-line SQL from my VB program. Thanks for any help!

G Received on Tue Apr 23 2002 - 08:23:55 CDT

Original text of this message

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