OraFAQ Forum: SQL & PL/SQL » after coding the sucessful cursor what are the steps to get the cursor output

Home » SQL & PL/SQL » SQL & PL/SQL » after coding the sucessful cursor what are the steps to get the cursor output

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

after coding the sucessful cursor what are the steps to get the cursor output [message #37497]

Tue, 12 February 2002 02:09

ranjan kumar dash
Messages: 15
Registered: February 2002

Junior Member

so after writting the cursor there is no need to do anything.Just in select statment u can see the changes being made to the tabels by cursor.

Report message to a moderator

Re: after coding the sucessful cursor what are the steps to get the cursor output [message #37498 is a reply to message #37497]

Tue, 12 February 2002 02:41

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

hi,

cursor does not make changes to tables.it is the pointer to the context area,maintained by oracle for record processing.

when u say open cursor. the associated sql query is executed and the output stays in the memory.you can loop thru (fetch..) it and retrieve the data.

i think u should read a llitle more regarding cursor.

cheers
pratap

Report message to a moderator

Previous Topic:	Dynamic sql and ' or "
Next Topic:	Help pls ...Unique constraint and Foreign Key

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 10 00:15:06 CST 2025