아래 데이터로 결과값이 나와야하는데.. 쿼리 부탁드립니다.
with t1 as ( select 1 no from dual union all select 2 from dual union all select 3 from dual )
-----------
결과값
----------
1-2
1-3
2-1
2-3
3-1
3-2
with t1 as ( select 1 no from dual union all select 2 from dual union all select 3 from dual ) SELECT a.no || '-' || b.no FROM t1 a , t1 b WHERE a.no != b.no