[Oracle] 각 Row Number 컬럼 곱하기

[Oracle] 각 Row Number 컬럼 곱하기

WITH TMP AS ( SELECT 1 NUM FROM DUAL UNION ALL SELECT 2 NUM FROM DUAL UNION ALL SELECT 3 NUM FROM DUAL UNION ALL SELECT 4 NUM FROM DUAL UNION ALL SELECT 5 NUM FROM DUAL UNION ALL SELECT 6 NUM FROM DUAL UNION ALL SELECT 7 NUM FROM DUAL UNION ALL SELECT 8 NUM FROM DUAL UNION ALL SELECT 9 NUM FROM DUAL UNION ALL SELECT 10 NUM FROM DUAL ), SIGN_VAL AS (SELECT CASE MOD (COUNT (*), 2) WHEN 0 THEN 1 ELSE -1 END VAL FROM TMP) SELECT EXP (SUM (LN (ABS (NUM)))) * VAL SUM_COL FROM TMP, SIGN_VAL GROUP BY VAL;

< Result >

SUM_COL

--------------------------

3628800