Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Explain different types of cursors?
- 6 Answers
- 29071 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
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Explain about network model?
Explain about xml databases?
What are the constraints on severity level in raiseerror?
What are data modelling techniques?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How is data stored in dbms?
How long can an error message be in raiseerror function?
What is the physical representation for a many-to-many relationship?
Explain the rollup operator?
Explain about a primary key?
Which four data types cannot be used as a return type from a user-defined function?
What is data modeling with example?
In which database can extended stored procedures be added?
What are the 18 schemas?
