Attributes of explicit cursor


Explain the attributes of explicit cursor.

<<Previous  Next>>

Oracle - Explain the attributes of explicit cursor - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

Explain the attributes of explicit cursor.

a. %FOUND - True, if the SQL statement has changed any rows.
b. %NOTFOUND - True, if record was not fetched successfully.
c. %ROWCOUNT - The number of rows affected by the SQL statement.
d. %ISOPEN - True, if there is a SQL statement being associated to the cursor or the cursor is open.

Oracle - Explain the attributes of explicit cursor - April 10, 2009 at 11:00 AM

Explain the attributes of explicit cursor.  

There are four attributes of explicit cursor in oracle.

This evaluates TRUE when cursor is open else FALSE.

This evaluates TRUE if last fetch succeeded.

Evaluates TRUE if last fetch failed.

This returns number of record fetched from active set.

Also read
Oracle cursors interview questions

What a SELECT FOR UPDATE cursor represent?, What WHERE CURRENT OF clause does in a cursor?, Can you pass a parameter to a cursor?, Explain the functioning of CURSOR FOR LOOP with example., Define Simple/Explicit , Parametric and Internal/Implicit cursor............

What is the difference between REF Cursor & Normal Cursor in oracle?

Normal cursors fall under the category of static cursors while REF cursors are dynamic.........

What is use of a cursor variable in oracle?

A cursor variable works like pointer in C. It is used to hold address of an item rather than the item itself. Cursor variables can be used to hold different values at run time............

What are the drawbacks of a cursor?

Implicit cursors are less efficient than explicit cursors, Implicit cursors are more vulnerable to data errors...........

What is a cursor variable?

A cursor variable is capable to get associated with different SELECT statements at run time. It is a reference type which is quite similar to pointer in C. In order to use cursor variable............ 

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring