insert into an xmltype table using a trigger
Hi guys.
I have not worked with xmltype tables before and am trying to integrate two different systems, one system is using xmltype tables and the other is using the normal tables. Is it possible to create trigger on table X that inserts values to table Z once a new row is inserted into table X? Any assitance will be appreciated, See below the example of the to tables.
========Normal table====
create table x (tans_id number(15),trans_date date,currency varchar2(3), amount number(15),account_no number(7) );
insert into x (trans_id,trans_date,currency,amount,account_no)
values(1,SYSDATE,'USD',3000,4780903)