March 21st, 2012, 12:51 PM
|
 |
Contributing User
|
|
|
|
Quote: | Originally Posted by hakeem777 I am running Oracle 9 and using sql loader to import text file into table. Can sql loader skips the record which blank line or carriage return? Do I need to set up with options? Please advise me how. Thanks. |
If the blank lines are at the beginning of the data file, use OPTIONS(SKIP=n), otherwise if the blank lines are in between data rows, use 'WHEN' as the following example:
Code:
load data
infile 'MyData.dat'
into table test_tab truncate
when id != BLANKS
fields terminated by ','
(id, ....etc...)
__________________
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
