Please help me with the following SQL in oracle (production):
Please help me with the following SQL in oracle (production):
*Original SQL*
SELECT 3002433348, C.CLASS_ID, 3000489536, 'Wind River', 'Wind River', NVL(MAX(D.SEQ),0) + 1,
TO_DATE('2016-04-27 12:12:12', 'YYYY-MM-DD HH24:MI:SS'), MAX(D.HIDDEN), 'system'
FROM UPS_CLASS_ATTR A, UPS_CLASS B, UPS_CLASS C, UPS_ATTR_REF D WHERE A.CLASS_ID = 1000000010
AND A.ATTR_ID = 3000489536 AND INHERITED = 0 AND A.CLASS_ID = B.CLASS_ID
AND C.CLASS_NAME LIKE B.CLASS_NAME || ' : %' AND B.CLASS_TYPE = C.CLASS_TYPE
AND C.CLASS_ID = D.CLASS_ID AND D.ATTR_ID = 3000489536 GROUP BY C.CLASS_ID
0