Hi, I'm working with some Oracle SQL as follows :
(And I want sql below expressed in splunk languages. The bold typed commands or functions are to be converted to splunk languages... Any suggestions??)
SELECT A.white,A.black,A.blue,A.oceanblue,A.yellow,A.red,A.gray,A.orange,A.margenta,B.purple,B.pink
,(TO_DATE(A.gray, 'YYYYMMDD') - TO_DATE(B.pink, 'YYYYMMDDHH24MISS')) AS DIFF_DAYS
,TO_CLOB(REPLACE(NVL(B.B1, ' '), CHR(13), '')
|| CASE WHEN B.B2 IS NOT NULL THEN CHR(10) || REPLACE(B.B2, CHR(13), '') END
|| CASE WHEN B.B3 IS NOT NULL THEN CHR(10) || REPLACE(B.B3, CHR(13), '') END
|| CASE WHEN B.B4 IS NOT NULL THEN CHR(10) || REPLACE(B.B4, CHR(13), '') END
|| CASE WHEN B.B5 IS NOT NULL THEN CHR(10) || REPLACE(B.B5, CHR(13), '') END
|| CASE WHEN B.B6 IS NOT NULL THEN CHR(10) || REPLACE(B.B6, CHR(13), '') END
|| CASE WHEN B.BCM IS NOT NULL THEN CHR(10) || REPLACE(B.BCM, CHR(13), '') END) RSLTCNT
,-1 * ROW_NUMBER() OVER (PARTITION BY A.white, A.black ORDER BY COALESCE(B.DEL, B.margenta), B.purple ) SEQ
FROM
INNER JOIN B ON A.white = B.white AND A.black = B.black
WHERE 1=1 AND A.gray <= COALESCE(B.DEL, B.orange)
UNION ALL
SELECT A.white,black,A.blue,A.oceanblue,A.yellow,A.red,A.gray,B.orange,B.margenta,B.purple,B.pink
,(TO_DATE(A.bluye, 'YYYYMMDD') - TO_DATE(B.pink, 'YYYYMMDDHH24MISS')) AS DIFF_DAYS
,TO_CLOB(REPLACE(NVL(B.B1, ' '), CHR(13), '')
|| CASE WHEN B.B2 IS NOT NULL THEN CHR(10) || REPLACE(B.B2, CHR(13), '') END
|| CASE WHEN B.B3 IS NOT NULL THEN CHR(10) || REPLACE(B.B3, CHR(13), '') END
|| CASE WHEN B.B4 IS NOT NULL THEN CHR(10) || REPLACE(B.B4, CHR(13), '') END
|| CASE WHEN B.B5 IS NOT NULL THEN CHR(10) || REPLACE(B.B5, CHR(13), '') END
|| CASE WHEN B.B6 IS NOT NULL THEN CHR(10) || REPLACE(B.B6, CHR(13), '') END
|| CASE WHEN B.BCM IS NOT NULL THEN CHR(10) || REPLACE(B.BCM , CHR(13), '') END) RSLTCNT
,ROW_NUMBER() OVER (PARTITION BY A.white, A.black ORDER BY B.pink DESC, B.purple DESC) SEQ
FROM
INNER JOIN B
ON A.white = B.white AND A.black = B.black
WHERE 1=1 AND NVL(A.gray, '99991231') > COALESCE(B.DEL, B.orange)
)
... View more