1 2 3 4 5 6 7 8 9 10 11 12 13 14
| MERGE into archi_table d
using (select '001ABC' as cod ,
'sad01235' as desig ,
to_date('14/03/2008', 'dd/mm/yyyy') as date_trait ,
'dsz' as ano ,
to_date('14/03/2008', 'dd/mm/yyyy') as date_export,
sysdate as date_archive
from dual) s
on (s.cod = d.cod)
WHEN MATCHED THEN
update set d.date_archive = s.date_archive
WHEN NOT MATCHED THEN
insert (d.cod, d.desig, d.date_trait, d.ano, d.date_export, d.date_archive)
values (s.cod, s.desig, s.date_trait, s.ano, s.date_export, s.date_archive); |
Partager