Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Loading from a column
Hello there!
I have a table (table1) and one of its columns DATA_X is CHAR(660)
I will create another table (table2) similar to the above but i will
replace the DATA_X column with several columns (different data types)
The table1 is populated with data using a text file. After the loading is finished on table1 i want to select all the data from table1 and load it in table2. The DATA_X must be split in several columns.
How do i perform this?
Thank you. Received on Thu Feb 05 2004 - 05:40:43 CST