Re: Loading from a column

From: Alistair Thomson <alistair_at_despammed.com>
Date: Thu, 5 Feb 2004 11:55:31 -0000
Message-ID: <bvtavk$r32$1$8300dec7@news.demon.co.uk>

Why not use sqlldr to load the data from the text file into table2? You can use the fixed column position or a delimiter to separate the data into different columns.

Alistair

"Demetris" <DMina_at_laiki.com> wrote in message news:c5285638.0402050340.3e482dc0_at_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:55:31 CST