OracleÆ´½Ó×Ö·û´®ÎÊÌâ

select A_NM || '----' || B_NM
  from (select distinct a.sttn_nm a_nm, b.sttn_nm b_nm
          from tb_sttn a, tb_sttn b
        where a.sttn_id < b.sttn_id)

ÕâÌõSQLÓï¾ä²éѯºóÔÚ½çÃæÉÏÏÔʾµÄÊÇ A_NM--/--/B_NM£¬²»ÖªµÀÔõô½â¾ö£¬¶øÏ£Íû³öÏÖµÄÊÇA_NM----B_NM£¬ ²»Çå³þ'/'ÊÇÔõô³öÀ´µÄ£¬Ôõôȥµô£¿ ллÀ²

---

²»»á°É..Êý¾Ý¿â×Ô×÷Ö÷ÕÅ
SQL code:
SQL> with tb_sttn as(
2 select rownum sttn_id,rownum||rownum sttn_nm from dual
3 connect by rownum<10)
4 select A_NM || '----' || B_NM
5 from (select distinct a.sttn_nm a_nm, b.sttn_nm b_nm
6 from tb_sttn a, tb_sttn b
7 where a.sttn_id < b.sttn_id)
8 ;

A_NM||'----'||B_NM
--------------------------------------------------------------------------------
11----44
22----55
33----55
11----22
11----66
22----33
22----44
44----55
88----99
44----77
44----99
11----88
55----66
66----88
11----33
44----88
55----88
22----88
11----55
11----77

A_NM||'----'||B_NM
--------------------------------------------------------------------------------
11----99
22----66
22----77
33----66
33----77
55----77
66----77
77----88
77----99
22----99
33----44
33----88
33----99
44----66
55----99
66----99

36 rows selected

---

ûÕâÇé¿ö·¢Éú...
{{-