How To Trim The Trailing White Space While Loading Data Using SQL*Loader
Last updated on NOVEMBER 24, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 188.8.131.52
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms