Does cursor hit database everytime ??
671480Dec 16 2009 — edited Dec 17 2009Hi seniors,
I am little confused with the concept of the cursor. I juts want to know is cursor has anything to deal with the database hit.
Explanation :
Say for example I have a cursor which is returning the 1000 rows from multiple table then that recordset will stored in some named sql area called cursor.
Now my question is when I loop the cursor will it get the actual data directly from the cursor OR It will just get an address location from the cursor to the actual database table or something.
If possible please help me to clear this doubt.
the reason being I have created one package which will move or drop the table with its all objects from all the schema available on the database server and it makes use of lot of cursor which are based on system views like all_table,all_trigger etc
Thanks in advance.