select ('Current user: '|| user) as Current_User from dual;
select ('DB: '||sys_context('USERENV', 'DB_NAME')) as DB from dual;
delete from XXX_AEI_PATCH_CURED_EVENT;
commit;
copy from &1 to &2 -
insert XXX_AEI_PATCH_CURED_EVENT -
( seq_id , -
bc , -
bus_rel_id , -
partner_id , -
ori_aei_status , -
new_aei_status , -
ori_expiry_date , -
new_expiry_date , -
aei_tech_id , -
batch_id , -
patch_status , -
CREATE_DATE , -
LAST_UPDATE_DATE , -
patch_msg -
)-
using select -
seq_id , -
bc , -
bus_rel_id , -
partner_id , -
ori_aei_status , -
new_aei_status , -
ori_expiry_date , -
new_expiry_date , -
aei_tech_id , -
batch_id , -
patch_status , -
CREATE_DATE , -
LAST_UPDATE_DATE , -
patch_msg -
from XXX_AEI_PATCH_CURED_EVENT ;
commit;
