rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

 

• %ROWCOUNT
• %NOTFOUND
• %FOUND
• %ISOPEN

syam sundar

• Aug 17th, 2007

 

%ROWTYPE - returns number of the rows which are fetched/updated/deleted
%ISOPEN    - returns true if the cursor is open
%FOUND     - returns true if the cursor fetched any row
%NOTFOUND-returns true if the cursor does not fetch any row

narmadac

 Profile Answers by narmadac 

• Feb 11th, 2010

 

Cursor attributes when appended to the cursor name allow the users to access useful information from the retrieved rows.  After opening a cursor a 'fetch' statement is used to fetch rows from the active set, one at a time.  The following attributes indicate whether fetch statement has failed or succeeded.

• %NOTFOUND  -  evaluates true when no records are found or when 'fetch' fails to return a row.
  
• %FOUND - evalutes true when records are found or when 'fetch' succeeds in returing rows.
  
• %ROWCOUNT - to return number of rows fetched or when 'fetch' returns the number is incremented.
  
• %ISOPEN - evaluates true when cursor is open else false.