Why does %isopen return false for an implicit cursor?

Answer Posted / kiran r

In Case of Implicit Cursor. it returns always false because the cursor automatically closes once it is Executed

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is normalization in sql?

529


What are primary key and foreign key and how they work?

556


What is oracle and pl sql?

663


What does (+) mean in sql joins?

528


What does select count (*) mean in sql?

552






What is insert command in sql?

528


What is error ora-01000: maximum open cursors exceeded

604


What are the two virtual tables available at the time of database trigger execution?

642


Can you inner join the same table?

527


Does sql between include endpoints?

554


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2009


How to change the order of columns in Oracle SQL Plus ?

616


What is the use of pl/sql table?

556


What is sql keyword?

564


explain the options of myisamchk to improve the performance of a table. : Sql dba

549