CREATE TABLE TEST_STR_TO_RAW
(
  REQ_ID   NUMBER,
  TAG_NM   VARCHAR2(20 BYTE),
  TAG_VAL  VARCHAR2(30 BYTE)
)


SQL LOADER CONTROL FILE
=========================
LOAD DATA
TRUNCATE
INTO TABLE TEST_STR_TO_RAW
FIELDS TERMINATED BY "~"
TRAILING NULLCOLS
(REQ_ID INTEGER EXTERNAL,
TAG_NM CHAR,
TAG_VAL "decode(:TAG_NM,'DB_PASSWORD',UTL_I18N.STRING_TO_RAW(:TAG_VAL),:TAG_NM,:TAG_VAL)"
)


TEST DATA
============
12345~FILE_TYP~Delimited
12345~DELIMITER~|
12345~TARGET_DB~TEST
12345~USER_NM~TESTUSR
12345~DB_PASSWORD~TESTPWD