Why does %isopen return false for an implicit cursor?

Question Posted / ramesh

1 Answers
1530 Views
I also Faced
E-Mail Answers

Why does %isopen return false for an implicit cursor?..

Answer / 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

More SQL PLSQL Interview Questions

What is sequence in sql?

0 Answers

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers IBM,

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers

Can dml statements be used in pl/sql?

0 Answers

What is bind variable in pl sql?

0 Answers

What does joining a thread mean?

0 Answers

What steps server process has to take to execute an update statement?

0 Answers

what is meant by urlencode and urldocode? : Sql dba

0 Answers

can we update a view which is created from two tables