Why does %isopen return false for an implicit cursor?



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

Can we join 3 tables in sql?

0 Answers  


how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,


can i call procedure in package

3 Answers   TCS,


how many columns can be used for creating index? : Sql dba

0 Answers  


What is a schema sql?

0 Answers  






how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  


What are variables in pl sql?

0 Answers  


Is oracle and sql same?

0 Answers  


What are the operators in sql?

0 Answers  


What is sql engine in oracle?

0 Answers  


write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,


what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,


Categories