Interview Questions

Implicit Cursor attributes

DATABASE Administrator (DBA) Interview Questions and Answers

(Continued from previous question...)

63. Implicit Cursor attributes

Same as explicit cursor but prefixed by the word SQL
SQL%Found, SQL%NOTFOUND, SQL%ROWCOUNT, SQL%ISOPEN
Tips :
1. Here SQL%ISOPEN is false, because oracle automatically closed the implicit cursor after executing SQL statements.
2. All are Boolean attributes.

(Continued on next question...)

Other Interview Questions