hello,
I have a problem and am wondering if anyone has got any ideas about how I should tackle it.
I have two tables : INSTRUMENT and CROSS_REFERENCE, the primary key in the INSTRUMENT table, it has 3 columns in it, is also anforeign key in the CROSS_REFERENCE table. I need to write a job that swaps the primary key of one instrument witht he primary key of another.
Currently I do it manually, and I am not allowed to turn off the constraints, or have a temporary table to load the data into. I had thought of using PL/SQL tables to store the rows and manipulate them in there . Does anyone have any thoughts on this ???
I have a problem and am wondering if anyone has got any ideas about how I should tackle it.
I have two tables : INSTRUMENT and CROSS_REFERENCE, the primary key in the INSTRUMENT table, it has 3 columns in it, is also anforeign key in the CROSS_REFERENCE table. I need to write a job that swaps the primary key of one instrument witht he primary key of another.
Currently I do it manually, and I am not allowed to turn off the constraints, or have a temporary table to load the data into. I had thought of using PL/SQL tables to store the rows and manipulate them in there . Does anyone have any thoughts on this ???