ora7

SELECT
RAWTOHEX(
STANDARD_HASH(
NVL(DBMS_LOB.SUBSTR(INTERNINSTID, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(INTERNVERSION, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(INTERNTIMESTAMP, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(INTERNRECTYPE, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(INTERNFIXSTRING, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(ORDERID, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(ACCOUNT, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(MERGEID, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(PARENTORDERID, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(SALESPERSONID, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(SYMBOL, 4000, 1), '') ||
NVL(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD'), '') ||
NVL(TO_CHAR(EXPIRETIME, 'HH24:MI:SS'), '') ||
NVL(DBMS_LOB.SUBSTR(LEAVESQTY, 4000, 1), '') ||
NVL(DBMS_LOB.SUBSTR(TIMEINFORCE, 4000, 1), '')
, 'MD5')
) AS row_hash
FROM CacheCplsOrder
ORDER BY
NVL(DBMS_LOB.SUBSTR(INTERNINSTID, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(INTERNVERSION, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(INTERNTIMESTAMP, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(INTERNRECTYPE, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(INTERNFIXSTRING, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(ORDERID, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(ACCOUNT, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(MERGEID, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(PARENTORDERID, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(SALESPERSONID, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(SYMBOL, 4000, 1), ''),
NVL(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD'), ''),
NVL(TO_CHAR(EXPIRETIME, 'HH24:MI:SS'), ''),
NVL(DBMS_LOB.SUBSTR(LEAVESQTY, 4000, 1), ''),
NVL(DBMS_LOB.SUBSTR(TIMEINFORCE, 4000, 1), '');