Unanswered: Create new table from other tables in oracle
Pls can someone assist on how to create a new table existing multiple oracle tables. The new table and the existing ones all have same no of column and column names. Also if it is otherwise, how can one create new table from existing ones with disimilar no of column and column names.
Is there no simpler way?
I have about 9 tables each with 112 columns. the columns are all same name, same datatype and i want to merge all the tables together into one big table since they have equal no of columns and column name. So i need to create a new table from those multiple tables not just s single table with few columns.
I want to popluate at thesame time the new table with all the data in the multiple tables.