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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Whether any commands are used for months calculation? If so, what are they?
What are the different windows events activated at runtime ?
What are the different types of modules in oracle forms?
How many types of auditing in Oracle?
How to set a transaction to be read only in oracle?
Can we save images in a database and if yes, how?
Point the difference between translate and replace?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
How do we display rows from the table without duplicates?
What is a Sequence ?
what is difference between foreign key and reference key