What are cursors? Explain different types of cursors?
- 6 Answers
- 27333 Views
- I also Faced
- E-Mail Answers
Answer Posted / daudkhan
A point to context area which has infromation for Oracle to
process SQL statements.
Cursors allow to fetch rows returned by a select statement.
Implicit cursor: Automatically declared
Explicit cursor: defined by programmer
| Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
How is data stored in dbms?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
fact table and dimension table containg one to many relationship or many to one relastionship
How can I detect whether a given connection is blocked?
Explain the rollup operator?
How to use online Backups?
How you can make a parameterized view?
How to combine two function together?
Who are end users in dbms?
Explain about the hierarchical model of the database?
Explain about the relational database?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is a database development?
Explain about relational database management systems?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
