what is the uses of cusor
Answers were Sorted based on User's Feedback
Answer / faize
when query is executed in oracle then result set is
produced & stored in the memory.Oracle allows the
programmer to access this resultset in the memory through
cursors
two types of cursors:
1.Explict cursor
2.Implict cursor
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ace dba
The DBA who has to performance troubleshoot you code when
you do row-at-a-time processing in a set-oriented database.
Or is that curser?
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kiran
it is the temporary space developed by the oracle server
when in an implicit cursor
and when a user wants to create a cursor then it is called
explicit cursor
so - any temporary place generated in the temporary memory
during the execution of sql query is called cursor
| Is This Answer Correct ? | 0 Yes | 3 No |
What is Database Link ?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to calculate date and time differences in oracle?
How to enter a new row into a table interactively?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
What is a Redo Log ?
What do you mean by a tablespace?
When can Hash Cluster used ?
what are corelated subqueries
25. Display the client number and the value of the highest value order placed by that client.
what is exact difference between drop and truncate table.
What is a system tablespace and when it is created?