ora2

SELECT
STANDARD_HASH(
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),''),
'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),'');