That's the book I have. I have not found any other books totally for
SQL*Loader.
Ken
-Original Message-
Sent: Wednesday, December 19, 2001 8:16 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: SQL Loader Load Problem
Ken,
Good to know that it worked.
Not
- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 11:30 AM
> With Oracle 7.3.4 you could use this method:
>
> LOAD DATA
> INFILE 'example.dat'
> BADFILE 'example.bad'
> insert
> INTO TABLE emp
> FIELDS TERMINATED BY ';'
> (empno POSITION(*),
> ename POSITI
nts of list ORACLE-L
Kirti:
Another person recommended this approach and it worked very nicely. To bad
it's not in the book.
Thanks much,
Ken
-Original Message-
Sent: Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Loa
Multiple recipients of list ORACLE-L
Subject: RE: SQL Loader Load Problem
Ken,
If you are using 8i, then you can use the 'filler' fields.
In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has column
Kirti:
Another person recommended this approach and it worked very nicely. To bad
it's not in the book.
Thanks much,
Ken
-Original Message-
Sent: Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SQL Loader Load Problem
Ken
Ken,
If you are using 8i, then you can use the 'filler' fields.
In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)
load data
infile 'myfile'
into table mytable
fields terminated by ','