So far,in PL/SQL I've declared my cursor with 3 columns.I am trying to use an if statement to update the salary. But I am stuck.
On Oct 13, 11:17 am, NewOracleMember <[EMAIL PROTECTED]> wrote: > DECLARE myRaise integer > SET myRaise = 50 > --declare the cursor > DECLARE mycursorname CURSOR FOR > SELECT EID, Name, Sal > FROM EMP > ORDER BY Sal DESC > OPEN mycursorname > > --load the cursor field values from that of the select statement > FETCH NEXT FROM mycursorname INTO @EID, @Name, @Sal > --loop thru the cursor until we are out of rows. > WHILE @@FETCH_STATUS = 0 > BEGIN > --give the employee the raise > UPDATE Emp SET Sal = Sal + myRaise > > --increment the variable by 50 for the next employee > myRaise = myRaise + 50 > > --move the cursor to the next record > FETCH NEXT FROM mycursorname INTO @EID, @Name, @Sal > END > CLOSE > > --clean up > DEALLOCATE mycursorname --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
