How To Specify The HEXADECIMAL Format For Field Delimiters?
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199 to 188.8.131.52 - Release: 9.2 to 11.2
Information in this document applies to any platform.
You can specify the delimiters in HEXADECIMAL format (i.e. X'<hexadecimal string>'). If HEXADECIMAL specification is not used, the delimiter specification is considered to be in the control file's character set (dictated by NLS_LANG). In this case, before searching for the delimiter in input data file, the delimiter is converted into the datafile's character set.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms