How to select from a table only the columns that exists in another table ?
Moved: Oracle PL/SQL Technical Forum
From: AICHAH ALHALAK 16-Jun-09 19:54
Subject: How to select from a table only the columns that exists in another table
Hi,
I have a very large table T1, 140 columns, that table used to be populated by a batch job every day from another schema table T2.
New changes were done to that table T2, 10 extra columns were added, plus the column order in not the same anymore.
Now, how can I still insert into T1, without having to list all the columns from the first table and the 2nd table:
This is how the old load job looked:
From: AICHAH ALHALAK 16-Jun-09 19:54
Subject: How to select from a table only the columns that exists in another table
Hi,
I have a very large table T1, 140 columns, that table used to be populated by a batch job every day from another schema table T2.
New changes were done to that table T2, 10 extra columns were added, plus the column order in not the same anymore.
Now, how can I still insert into T1, without having to list all the columns from the first table and the 2nd table:
This is how the old load job looked:
0