OraFAQ Forum: SQL & PL/SQL » How to Query a cursor

Home » SQL & PL/SQL » SQL & PL/SQL » How to Query a cursor

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Query a cursor [message #41248]

Thu, 12 December 2002 01:39

vivek
Messages: 59
Registered: October 2001

Member

How to query from a cursor variable.
Assume cursor as a table.

Report message to a moderator

Re: How to Query a cursor [message #41251 is a reply to message #41248]

Thu, 12 December 2002 06:01

B
Messages: 327
Registered: August 1999

Senior Member

don't understand Ur question ... please clarify

Report message to a moderator

Re: How to Query a cursor [message #41274 is a reply to message #41248]

Thu, 12 December 2002 16:37

Raj
Messages: 411
Registered: November 1998

Senior Member

FETCH NEXT FROM <cursor name> INTO :x, :y, :z
FETCH PRIOR FROM <cursor name> INTO :x, :y, :z
FETCH FIRST FROM <cursor name> INTO :x, :y, :z
FETCH LAST FROM <cursor name> INTO :x, :y, :z

FETCH ABSOLUTE <Row number in cursor> FROM <cursor name> INTO :x, :y, :z
FETCH RELATIVE <Row number in cursor> FROM <cursor name> INTO :x, :y, :z

Report message to a moderator

Previous Topic:	How can I see the object which is using some other object?
Next Topic:	Select * & REF CURSOR in pl sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 05:49:30 CDT 2024