Multiple choice technology databases

SQL%ISOPEN attribute always returns null in implicit Cursors.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle PL/SQL, implicit cursors are automatically managed by the Oracle engine for SQL statements like SELECT, INSERT, UPDATE, DELETE. The SQL%ISOPEN attribute is used to check if a cursor is currently open. For implicit cursors, Oracle automatically opens, executes, and closes the cursor, so SQL%ISOPEN always returns FALSE (not NULL) for implicit cursors because they're never left open - the engine handles everything. NULL is different from FALSE; NULL represents an unknown value.

Keep practicing — related questions