priya

It returns the Boolean value TRUE if no rows were processed. In PL/SQL, the cursor attribute SQL%NOTFOUND is a boolean attribute that evaluates to TRUE if a cursor fetch returns no rows. It is commonly used to check whether a cursor has reached the end of the result set. Here’s a brief explanation: If SQL%NOTFOUND … Read more

It returns the Boolean value TRUE if at least one row was processed. In PL/SQL, the cursor attribute SQL%FOUND is used to check whether the last SQL operation (query) on a cursor returned at least one row. If the most recent fetch or execute on the cursor returned one or more rows, then SQL%FOUND will … Read more

The cursor attribute SQL%ROWCOUNT will return the number of rows that are processed by a SQL statement. In PL/SQL, the cursor attribute SQL%ROWCOUNT returns the number of rows that were affected by the most recent SQL statement executed. It is often used to determine how many rows were affected by operations like INSERT, UPDATE, or … Read more

Implicit cursor is implicitly declared by Oracle. This is a cursor to all the DDL and DML commands that return only one row. Explicit cursor is created for queries returning multiple rows. In PL/SQL, implicit and explicit cursors refer to two different ways of handling queries and processing result sets. Implicit Cursors: Implicit cursors are … Read more

Oracle uses workspaces to execute the SQL commands. When Oracle processes a SQL command, it opens an area in the memory called Private SQL Area. This area is identified by the cursor. It allows programmers to name this area and access it?s information. In PL/SQL, a cursor is a named private SQL area where you … Read more