Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Explain different types of cursors?
- 6 Answers
- 29072 Views
- I also Faced
- E-Mail Answers
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 can I detect whether a given connection is blocked?
What is DB Development software?
What is a database development?
Which data type cannot be used as a parameter in a udf?
Explain about the storage and physical database design?
How to replace not in with not exist?
How would you design a database for an online site, which would average a million hits a day?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Why does this query return 0?
Explain about relational 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?
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 query and reporting.
How to generate OIDS
How long can an error message be in raiseerror function?
