kurs:tri_2
Differences
This shows you the differences between two versions of the page.
|
kurs:tri_2 [2014/09/10 21:22] |
kurs:tri_2 [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | === Insert, Update, Delete === | ||
| + | ^ Timing | After| | ||
| + | ^ Object Event | Inseert, Update, Delete | | ||
| + | ^ Fire for | Each Row | | ||
| + | <code> | ||
| + | declare | ||
| + | v_mode varchar2(10); | ||
| + | begin | ||
| + | if inserting then | ||
| + | v_mode := 'I'; | ||
| + | elsif updating then | ||
| + | v_mode := 'U'; | ||
| + | else | ||
| + | v_mode := 'D'; | ||
| + | end if; | ||
| + | insert into XL_TEST_JN | ||
| + | (wert, | ||
| + | change_date, | ||
| + | change_type, | ||
| + | orig_ind) | ||
| + | values | ||
| + | -- nvl() gibt den ersten (von zwei) Wert zurück, der nicht null ist. | ||
| + | (nvl(:old.wert, :new.wert), | ||
| + | sysdate, | ||
| + | v_mode, | ||
| + | nvl(:old.ind, :new.ind)); | ||
| + | end; | ||
| + | </code> | ||
kurs/tri_2.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
