Wednesday 13 March 2013

What are attributes of cursor?

·         SQL%ROWCOUNT: Number of rows affected by most recent SQL statement.
·         SQL%FOUND: Boolean attribute that evaluates to TRUE if most recent SQL statement affects one or more rows.
·         SQL%NOTFOUND: Boolean attribute that evaluates to TRUE if most recent SQL statement does not affect any row.
·         SQL%ISOPEN: Always evaluates to FALSE because P/L SQL closes implicit cursors immediately after they are executed.

No comments:

Post a Comment