kurs:bonus_journal_trigger
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
kurs:bonus_journal_trigger [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:bonus_journal_trigger [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 61: | Line 61: | ||
| nvl(:old.last_name, :new.last_name), | nvl(:old.last_name, :new.last_name), | ||
| nvl(:old.first_name, :new.first_name), | nvl(:old.first_name, :new.first_name), | ||
| - | nvl(:new.salary, null), | + | :new.salary, |
| - | nvl(:old.salary, null), | + | :old.salary, |
| nvl(:old.bonus, :new.bonus), | nvl(:old.bonus, :new.bonus), | ||
| sysdate, | sysdate, | ||
kurs/bonus_journal_trigger.txt · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
