궁금합니다.
1~500까지의 데이터가 있고,
C001, C002, C003, C005 데이터가 있습니다..
두개를 조인해서 최종 결과물이
C004
C006
C007
......
C499
C500
이렇게 되는 쿼리 질문이요 ㅠㅠ
select a.code from ( select 'C'||to_char(level, 'fm000') code from dual connect by level <= 500 ) a , ( select 'C001' code from dual union all select 'C002' from dual union all select 'C003' from dual union all select 'C005' from dual ) b where a.code = b.code (+) and b.code is null order by 1
select code from ( select 'C'||to_char(level, 'fm000') code from dual connect by level <= 500 ) minus ( select 'C001' code from dual union all select 'C002' from dual union all select 'C003' from dual union all select 'C005' from dual ) order by 1
감사합니다. ㅎㅎ