Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How do I do a simple select in a stored procedure
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