Interested to Buy Any Domain ? << Click Here >> for more details...
what is the uses of cusor
- 3 Answers
- 5603 Views
- Perot Systems, I also Faced
- E-Mail Answers
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 |
How do I connect to oracle?
How to recover a dropped table in oracle?
What are the differences between number and binary_float in oracle?
What are the advantages of oracle 12c?
How to find the duplicate rows count from employees table in oracle?
where do i find oracle interview questions.
Explain the use of tables option in exp command.
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
what is the syntax of UPDATE command?
Find all employees in Dept “Marketing”.
What happens if variable names collide with table/column names?
What is autonomous transaction?
Oracle General 
