possible in PL/SQL (and any other language). That way, you give the compiler maximum freedom to optimization. -- Create Driver for Test I generate 100,000 rows for my cursor using by CONNECT BY LEVEL ...

To create a cursor using PL/SQL. Steps: 1.Create employee table with following attributes (empid NUMBER, empname VARCHAR(10), dept VARCHAR(10),salary NUMBER); 2.Create a cursor named as ...