How To Specify The HEXADECIMAL Format For Field Delimiters?

(Doc ID 736237.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 9.2 to 11.2
Information in this document applies to any platform.


How to specify the HEXADECIMAL format for field delimiters?

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms