What are cursors? Explain different types of cursors?
Answer Posted / ramesh
Implicit Cursors --Occurs on behalf of every sql statement
Explicit Cursors --Named Cursors used in Plsql
Paramaeteried Cursors --Pass Paramters to a Named Cursor
Cheers,
Ramesh
Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
How would you design a database for an online site, which would average a million hits a day?
What are the three basic rules which are to be followed for the relational model of the database?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
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?
Explain the cube operator?
State the acid rules?
What is dbms and its application?
Which four data types cannot be used as a return type from a user-defined function?
fact table and dimension table containg one to many relationship or many to one relastionship
Why does this query return 0?
What is the database development process?
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?
What is data modeling with example?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain what a database is?