Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Explain different types of cursors?
- 6 Answers
- 28503 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
Explain about the database management systems.
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How to use timestamp datatypes
How to combine two function together?
Explain the rollup operator?
Explain about the hierarchical model of the database?
Which four data types cannot be used as a return type from a user-defined function?
Explain about query and reporting.
What is a database development?
How to replace not in with not exist?
I have a few records all are same structures data, I want to store data in multiple targets how
How to read and create .LDC data files which are used by linguatic dictionary.
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Which data type cannot be used as a parameter in a udf?
Who are naive users?
