Search Results

Here it is..

LOAD DATA
INTO TABLE TAB
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
ID CHAR(3),
CA CHAR(12),
ES CHAR(12),
EN CHAR(12)
)

Hi,
I've a batch program that load data from a file like:

00000013|FERRAN|JULIAN|GONZALEZ|1|
00000014|FRANCESC|NARVAEZ|PAZOS|1|
00000015|INMACULADA|MAYOL|BELTRAN|2|

I used the sqlldr command...