Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Loading from a column

Loading from a column

From: Demetris <DMina_at_laiki.com>
Date: 5 Feb 2004 03:40:43 -0800
Message-ID: <c5285638.0402050340.3e482dc0@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US