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

Home -> Community -> Usenet -> c.d.o.tools -> append records from flatfile via SQLLDR ?

append records from flatfile via SQLLDR ?

From: Susie Grace <hlng_at_usa.net>
Date: 2000/07/08
Message-ID: <8k6bq0$n65$1@nnrp1.deja.com>#1/1

how does one append records from a flat file to an existing file that is already populated using SQLLDR?

I know the syntax for INSERTING records into a BLANK table:

LOAD DATA
INFILE '/dbraid/ida1-00/home/applmgr/fixed_assets.dat' INTO TABLE apps.fixed_assets
(

 dept   	INTEGER EXTERNAL TERMINATED BY ',' ,
 asset_no       INTEGER EXTERNAL TERMINATED BY ',' ,
 description   	CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
 in_service	DATE "DD-MON-RR" TERMINATED BY ',' ,
 method	 	CHAR TERMINATED BY ',' ,
 yr_mo  	DECIMAL EXTERNAL TERMINATED BY ',' ,
 cost   	DECIMAL EXTERNAL TERMINATED BY ',' ,
 amount 	DECIMAL EXTERNAL TERMINATED BY ',' ,
 depreciation	DECIMAL EXTERNAL TERMINATED BY ',' ,
 reserve	DECIMAL EXTERNAL TERMINATED BY ',' ,
 percent	DECIMAL EXTERNAL TERMINATED BY ',' ,
 t_f    	CHAR

)

but how can I modify this so that additional files can be processed later? Thanks, and sorry for the wordiness.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jul 08 2000 - 00:00:00 CDT

Original text of this message

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