Interested to Buy Any Domain ? << Click Here >> for more details...
what is the uses of cusor
- 3 Answers
- 5702 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 |
What is the difference between online and offline backups?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
How to start your 10g xe server?
what is difference between cartesian join & cross join even they give same result?
What is the function of Redo Log ?
What is the fastest query method to fetch data from the table?
Youre getting high busy buffer waits - how can you find whats causing it?
Define the terms primary key foreign key and also the difference between primary and the unique key
How you open and close a cursor variable.Why it is required?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What is a read write transaction in oracle?
Explain the use of show option in imp command.
Oracle General 
