Re: Data Loading

From: Roar Pettersen <roarp_at_bigfoot.com>
Date: 24 Jul 1998 12:09:39 +0200
Message-ID: <usojrlfvg.fsf@bigfoot.com>

paulkcng_at_news.netvigator.com (Ng K C Paul) writes:
> 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?

sqlldr (sql loader)
Check out "server utilities" manual. (at least for oracle 7...)

--
Roar Pettersen
roarp_at_bigfoot.com Received on Fri Jul 24 1998 - 05:09:39 CDT