What are Explicit Cursor attributes?

Question

In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why?

Answer 1

Both explicit and implicit cursors have four attributes. They are
1.%FOUND-Returns TRUE if record was fetched successfully, FALSE otherwise.
2.%NOTFOUND-Returns TRUE if record was not fetched successfully, FALSE otherwise.
3.%ROWCOUNT-Returns number of records fetched from cursor at that point in time.
4.%ISOPEN-Returns TRUE if cursor is open, FALSE otherwise.