Support
Orange Support > 문의하기
Q & A
SQL 포맷터 개선 요청 (Orange for Oracle v7)
|
ASIS |
TOBE |
SQL |
UNION ALL SELECT 'SALE_QTY_D' AS GUBUN , COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD , SUM(QTY) AS QTY , SUM(QTY*TAG_PRCE) AS TAG_AMT , SUM(QTY*COST_PRCE) AS COST_AMT , SUM(SALE_AMT) AS SALE_AMT FROM V_SLPD WHERE 1=1 AND BIZ_DIV != 400 GROUP BY COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD UNION ALL SELECT 'SALE_QTY_O' AS GUBUN , COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD , SUM(QTY) AS QTY , SUM(QTY*TAG_PRCE) AS TAG_AMT , SUM(QTY*COST_PRCE) AS COST_AMT , SUM(SALE_AMT) AS SALE_AMT FROM V_SLPD WHERE 1=1 AND BIZ_DIV = 400 GROUP BY COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD |
UNION ALL SELECT 'SALE_QTY_D' AS GUBUN , COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD , SUM(QTY) AS QTY , SUM(QTY*TAG_PRCE) AS TAG_AMT , SUM(QTY*COST_PRCE) AS COST_AMT , SUM(SALE_AMT) AS SALE_AMT FROM V_SLPD WHERE 1=1 AND BIZ_DIV != 400 GROUP BY COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD UNION ALL SELECT 'SALE_QTY_O' AS GUBUN , COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD , SUM(QTY) AS QTY , SUM(QTY*TAG_PRCE) AS TAG_AMT , SUM(QTY*COST_PRCE) AS COST_AMT , SUM(SALE_AMT) AS SALE_AMT FROM V_SLPD WHERE 1=1 AND BIZ_DIV = 400 GROUP BY COMP_CD, BR_CD, YEAR_CD, SESN_CD, STY_CD |
SQL 포맷터 개선 요청 (Orange for Oracle v7)
임호균
2025.06.11
RE: SQL 포맷터 개선 요청 (Orange for Oracle v7)
오렌지팀
2025.06.16