pra10

SELECT
ORDERID,
DBMS_LOB.GETLENGTH(INTERNFIXSTRING) AS total_bytes,
-- Count how many actual characters exist
LENGTH(INTERNFIXSTRING) AS non_null_chars,
-- Show first 20 bytes as hex
RAWTOHEX(
UTL_RAW.CAST_TO_RAW(
CONVERT(DBMS_LOB.SUBSTR(INTERNFIXSTRING, 20, 1), 'AL32UTF8', 'AL32UTF8')
)
) AS first_20_hex
FROM CACHECPLSORDER
WHERE INTERNTIMESTAMP = TO_TIMESTAMP('2012-05-21 19:28:19:680', 'YYYY-MM-DD HH24:MI:SS:FF3');