Home » SQL & PL/SQL » SQL & PL/SQL » after coding the sucessful cursor what are the steps to get the cursor output
after coding the sucessful cursor what are the steps to get the cursor output [message #37497] Tue, 12 February 2002 02:09 Go to next message
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.
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 Go to previous message
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
Previous Topic: Dynamic sql and ' or "
Next Topic: Help pls ...Unique constraint and Foreign Key
Goto Forum:
  


Current Time: Sun Sep 19 03:19:23 CDT 2021