7 lines
251 B
SQL
7 lines
251 B
SQL
update mld_melding set mld_melding_status = 5, mld_melding_afgemeld = sysdate, mld_melding_afgemeld_user = 1042
|
|
where mld_melding_status = 4
|
|
and mld_melding_datum < to_date ('20051201', 'yyyymmdd')
|
|
and mld_ins_discipline_key = 589;
|
|
|
|
commit;
|