Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Explain different types of cursors?
- 6 Answers
- 29087 Views
- I also Faced
- E-Mail Answers
Answer Posted / banoj swain
cursor is nothing but a pointer pointing to the context area assigned by oracle for processing of sql statement.pl/sql programs control context area by using cursor.
types:1)static 2)dynamic or ref cursor
again static is of two types
1)explicit 2)implicit
dynamic of two types:
1)strong 2)weak
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
Write the fastest query to find out how many rows exist in a table?
How to replace not in with not exist?
What are the three types of database design?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
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?
What are the key features of dbms?
What are the three basic rules which are to be followed for the relational model of the database?
Explain about normal forms?
What is the database development process?
In which table collections errors are stored.
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is database design and development?
explain detail about ftp in datastage?
