Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to remove blank lines in a file while loading to DB using SQL *Loader

Oracle_WalkerJan 10 2012 — edited Jan 10 2012
I have a text file to be uploaded to DB. I am using SQL *Loader 10.2 to do this. My text file contains some blank lines and i want them to be removed. Below is my control file
LOAD DATA
CHARACTERSET UTF8
INTO TABLE LOAD_TEMP APPEND
fields terminated by ","
TRAILING NULLCOLS
(
ADDRESS,
UPDATE_DATE "to_char(SYSDATE,'YYYY-MM-DD')",
SEQ_NO SEQUENCE(MAX,1)
)
I can't be able to use 
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
to remove blank rows.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2012
Added on Jan 10 2012
#data, #database, #database-key-features, #export-import-sql-loader-external-tables, #table
1 comment
1,362 views