Multiple choice technology databases

What are the Sql Cursor Attributes in Pl/sql?

  1. SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN

  2. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN

  3. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The four standard implicit cursor attributes in Oracle PL/SQL are SQL%FOUND, SQL%NOTFOUND, SQL%ROWCOUNT, and SQL%ISOPEN. SQL%ISFOUND and SQL%OPEN do not exist in PL/SQL. Therefore, the option containing SQL%ROWCOUNT, SQL%FOUND, SQL%NOTFOUND, SQL%ISOPEN is correct.

Keep practicing — related questions