Exit a LOOP when cursor%NOTFOUND

The Oracle PL/SQL EXIT statement is used to skip the current block. It can be used to terminate loops or stop processing based on a condition you specify.When we give  EXIT statement forces a loop to complete immediately and unconditionally.Control is then passed to the next statement (if any).DECLARE   CURSOR EMPCUR    IS ...

Read More

Explicit Cursor Example

The following short example of a PL/SQL anonymous block prints the names of all employees in  specified department  in the Employees  table, using the DBMS_OUTPUT package:The syntax for creating an explicit cursor is :CURSOR cursor_name IS select_statement;Working with an explicit cursor involves four steps:Declaring the cursor...

Read More