Move several fields from multiple tables to a new table
Good Morning.
I have just inherited a database and it has 5 tables which all have the same fields,
For example,
Table Name "OperationsNW" has a unique key of OpsNo
Fields contain Materials01, Materials02, Materials03,
Next Table is
Table Name "OperationsNE" has a unique key of OpsNo
Fields contain Materials01, Materials02, Materials03,
This goes on in the 5 tables, but have many more repeated fields.
I would like to have a separate table called Materials and have Materials01, Materials02, Materials03 but how can I migrate the individual tables from the different Operations tables into Materials?
Thanks
Subject
Written By
Posted
Move several fields from multiple tables to a new table
November 18, 2021 04:49AM
November 18, 2021 09:11AM
November 20, 2021 05:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.