ora

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

sqlplus -S $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID <<EOF \
| tr -d '\n' | md5sum | awk '{print $1}'