쿼리를 정리해서 다시 글 올립니다. 제가 내용을 착각했습니다....
B.SUBCODE 가 NULL 인 것이 아니라 조건에 없으면
SELECT A.CODE, A.VALUE FROM A, B
WHERE A.CODE=B.SUBCODE AND B.NO='123'
GROUP BY A.CODE, A.VALUE ORDER BY A.CODE
조건에 있으면
SELECT A.CODE, A.VALUE FROM A, B
WHERE A.CODE=B.SUBCODE AND B.NO='123' AND B.SUBCODE='123001'
GROUP BY A.CODE, A.VALUE ORDER BY A.CODE
하도록 실행하고 싶은 것입니다.
SELECT a.code, a.value FROM a , b WHERE a.code = b.subcode AND b.no = '123' AND ( :v_subcode IS NULL OR b.subcode = :v_subcode ) GROUP BY a.code, a.value ORDER BY a.code ;
SELECT a.code, a.value FROM a , b WHERE a.code = b.subcode AND b.no = '123' AND b.subcode = NVL(:v_subcode, b.subcode) GROUP BY a.code, a.value ORDER BY a.code ;