Re: Data Loading

From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: Tue, 28 Jul 1998 23:56:32 GMT
Message-ID: <01bdba83$5c7e38e0$049a0580@mcb>

For data from a file, use SQL*Loader.

For insert statements, if you explicitly state the columns you want to insert to, as long as a column isn't dropped (well, table copied, table dropped, recreated, yadda, yadda, yadda), you don't have to worry about the order of the columns in the database. This might cut down on some maintenance.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Ng K C Paul <paulkcng_at_news.netvigator.com> wrote in article <6p8rk9$as4$4_at_imsp009a.netvigator.com>...
> Is there any good method to load the data into the table other than using

> a lot of insert statements to insert data to ORACLE? Since my table
> definition may change at any time, e.g. add column, it is not a good
> approach to maintain the insert statements. If I use Excel to store and
> manipulate the data, is there any fast solution to copy data in?
>
Received on Tue Jul 28 1998 - 18:56:32 CDT