ora4

SELECT RAWTOHEX(
DBMS_CRYPTO.HASH(
UTL_RAW.CAST_TO_RAW(
NVL(TRIM(TO_CHAR(INTERNINSTID)), '') ||
NVL(TRIM(TO_CHAR(INTERNVERSION)), '') ||
NVL(TRIM(TO_CHAR(INTERNTIMESTAMP)), '') ||
NVL(TRIM(TO_CHAR(INTERNRECTYPE)), '') ||
NVL(TRIM(TO_CHAR(INTERNFIXSTRING)), '') ||
NVL(TRIM(TO_CHAR(ORDERID)), '') ||
NVL(TRIM(TO_CHAR(ACCOUNT)), '') ||
NVL(TRIM(TO_CHAR(MERGEID)), '') ||
NVL(TRIM(TO_CHAR(PARENTORDERID)), '') ||
NVL(TRIM(TO_CHAR(SALESPERSONID)), '') ||
NVL(TRIM(TO_CHAR(SYMBOL)), '') ||
NVL(TRIM(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD')), '') ||
NVL(TRIM(TO_CHAR(EXPIRETIME, 'HH24:MI:SS')), '') ||
NVL(TRIM(TO_CHAR(LEAVESQTY)), '') ||
NVL(TRIM(TO_CHAR(TIMEINFORCE)), '')
),
DBMS_CRYPTO.HASH_MD5
)
) AS row_hash
FROM CacheCplsOrder
ORDER BY
NVL(TRIM(TO_CHAR(INTERNINSTID)), ''),
NVL(TRIM(TO_CHAR(INTERNVERSION)), ''),
NVL(TRIM(TO_CHAR(INTERNTIMESTAMP)), ''),
NVL(TRIM(TO_CHAR(INTERNRECTYPE)), ''),
NVL(TRIM(TO_CHAR(INTERNFIXSTRING)), ''),
NVL(TRIM(TO_CHAR(ORDERID)), ''),
NVL(TRIM(TO_CHAR(ACCOUNT)), ''),
NVL(TRIM(TO_CHAR(MERGEID)), ''),
NVL(TRIM(TO_CHAR(PARENTORDERID)), ''),
NVL(TRIM(TO_CHAR(SALESPERSONID)), ''),
NVL(TRIM(TO_CHAR(SYMBOL)), ''),
NVL(TRIM(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD')), ''),
NVL(TRIM(TO_CHAR(EXPIRETIME, 'HH24:MI:SS')), ''),
NVL(TRIM(TO_CHAR(LEAVESQTY)), ''),
NVL(TRIM(TO_CHAR(TIMEINFORCE)), '');