(1) ๊ณ ๋ํ
(1) [SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(1)-์ํธํ๋12๋ฒ
(2) [SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(1)-์ํธํ๋13๋ฒ
(3) [SQLP์ค๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(1)-์ํธํ๋14๋ฒ
(1) [SQLPํ๊ธฐํ์ด]6์ฅ ๊ณ ๊ธSQLํ๋(1)-์ํธํ๋
[SQLPํ๊ธฐ๋ฌธ์ ]6์ฅ ๊ณ ๊ธSQLํ๋(1)-์ํธํ๋ 10๋ฒ
-- NL_SJ ์กฐ์ธ์
SELECT /*+ LEADING(P) */
P. ์ํ๋ฒํธ, P. ์ํ๋ช
, P.์ํ๊ฐ๊ฒฉ, P.์ํ๋ถ๋ฅ์ฝ๋
FROM ์ํ P
WHERE
P.์ํ์ ํ์ฝ๋ = :PCLSCD
AND EXISTS ( SELECT /*+ UNNEST NL_SJ */ 'X'
FROM ๊ณ์ฝ C
WHERE C.์ํ๋ฒํธ = P.์ํ๋ฒํธ
AND C.๊ณ์ฝ์ผ์ >= TRUNC(ADD_MONTHS(SYSDATE, -12))
);
-- ์กฐ์ธ์๋ ์ํ๊ณ EXSISTS ๋ฌธ์ผ๋ก ์คํ์
SELECT /*+ LEADING(P) */
P. ์ํ๋ฒํธ, P. ์ํ๋ช
, P.์ํ๊ฐ๊ฒฉ, P.์ํ๋ถ๋ฅ์ฝ๋
FROM ์ํ P
WHERE
P.์ํ์ ํ์ฝ๋ = :PCLSCD
AND EXISTS ( SELECT /*+ NO_UNNEST */ 'X'
FROM ๊ณ์ฝ C
WHERE C.์ํ๋ฒํธ = P.์ํ๋ฒํธ
AND C.๊ณ์ฝ์ผ์ >= TRUNC(ADD_MONTHS(SYSDATE, -12))
);