I face problems to extract data from one table and insert it in another one
634644Oct 21 2009 — edited Oct 23 2009Hi,
For modifications, I have to extract data from one table and insert it in another one, after this I have to get the new id from the second table and place it in the first table.
More or less, it should be so:
For every record loop
select law_item from table_one;
insert law_item into table_two;
insert into table one(law_id) values(table_two_sequence.currval);
End loop;
I saw (and I tried) many thing on Internet... (as type, bulk collect...) but did not succeeded in it.
Does anybody have a solution ?
Thank you in advance from Belgium-)
Michel