WITH ASSERT (G, N, N2) AS (
SELECT 'SL', 2264, 2040 FROM DUAL
UNION ALL SELECT 'SH', 22634, 20380 FROM DUAL
)
SELECT
G AS PRICE_GRADE -- 등급
,N AS COST -- 원가1 D4
,N2 AS COST2 -- 원가2 D4
FROM ASSERT;
WITH ASSERT (G, N, N2) AS (
SELECT 'SL', 2264, 2040 FROM DUAL
UNION ALL SELECT 'SH', 22634, 20380 FROM DUAL
)
SELECT
G AS PRICE_GRADE -- 등급
,N AS COST -- 원가1 D4
,N2 AS COST2 -- 원가2 D4
FROM ASSERT;