Attributes of Explicit Cursors

Attributes of Explicit Cursors

In Oracle Every cursor has  a four attributes .

%NOTFOUND
%FOUND
%ROWCOUNT
%ISOPEN


%NOTFOUND
evaluates to TRUE if last FETCH failed because no more rows were available
evaluates to FALSE if last FETCH returned a row

%FOUND
evaluates to TRUE if last FETCH returned a row
evaluates to FALSE if last FETCH failed because no more rows were available

%ROWCOUNT
returns the number of rows FETCHed from the active set so far

%ISOPEN
evaluates to TRUE if an explicit cursor is open
evaluates to FALSE if an explicit cursor is closed