Oracle and PL/SQL Help [message #8057] |
Wed, 23 July 2003 18:08 |
Nazma Bepat
Messages: 34 Registered: May 2003
|
Member |
|
|
Would someone be willing to help me out.
I would like to rewrite the cursor below, with the minimum number of lines, using the syntax for cursor For Loops. I would not like to change the cursor name, columns or any variables used in the code below. I would like to write the code to create the cursor For Loop.
DECLARE
social_benefits c_unions%ROWTYPE;
CURSOR change_cursor IS
SELECT wk_ends, forty_hr_wks, ot_pay
FROM bus_practices;
BEGIN
OPEN change_cursor;
LOOP
FETCH change_cursor INTO social_benefits;
EXIT WHEN change_cursor &NOTFOUND;
END LOOP;
CLOSE change_cursor;
END;
/
I really appreciate your help.
Thanks
Nazma
|
|
|
|
|