| Re: Loading data into a table [message #375225] |
Tue, 07 August 2001 08:40 |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
use SQLLOADER to load data from flat file into database table
here i am giving sample control file which instructs sqlloader how to load data and inserts sequence numbers in one field..
control file :
LOAD DATA
INFILE sample.TXT'
APPEND
INTO TABLE sample_table
(seqno sequence(max,1) ,
sdata1 POSITION(1:10),
sdata2 POSITION(11:30) )
sequence is reserved word in above sample control file. you dont need to create any sequence object.
HTH
SUresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
