How To Trim The Trailing White Space While Loading Data Using SQL*Loader
(Doc ID 331366.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168
Information in this document applies to any platform.
INTO table test_import
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
diff TERMINATED BY whitespace
Note: In this code T_NAME column is of length 24 in the table, whereas the data which is flowing from the data file is only 15 characters long and rest is trailing white space.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document