On Oct 13, 9:28 am, NewOracleMember <[EMAIL PROTECTED]> wrote: > 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. >
where's the bit that requires an if for the update? your update looks like it might update the whole table. you might want to look up the 'where current of' clause for the update statement. and you might also want to look at cursor for loops, which are kind of an oracle shortcut for using cursors and loops. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
