SQL*Loader Assistance Loading HEX Field
(Doc ID 2212452.1)
Last updated on OCTOBER 14, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
How to insert HEX data into a table?
This document helps to understand how to insert HEX data into a table with conversion directly in the CONTROL file to a VARCHAR/CHAR.
i.e Generally if we load RAW data into an Oracle table the RAW field contents will be in HEX data format and later conversion needs to be done through utl_raw.cast_to_varchar2.
But is there a way to go from the HEX value in the input (flat) file straight to a readable VARCHAR/CHAR field in a table?
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