ÇósqlÓï¾ä

pln_id memo
  1    ÎÒÊÇ
  1    ÄãºÃ
  2    ÄãÊÇ
  2    ÎÒºÃ

½á¹û

  pln_id memo 
    1  ÎÒÊÇÄãºÃ
    2  ÄãÊÇÎÒºÃ

---

ÄãµÄOracle ʲô°æ±¾£¿

---

10g°¡

---

Äã×Ô¼º¾õµÃÓÐʲô¹æÂÉÂð?ÄãÌùµÄÊý¾Ý½öÊÇʾÀýÊý¾Ý°É

---

SQL code:

SQL> select * from t;

IDX NAME
--------------------------------------- ----------------------------------------
1 ÎÒÊÇ
1 ÉñÏÉ
2 ÎÒÊÇ
2 ÉñÏÉ

SQL>
SQL> select idx,replace(wmsys.wm_concat(name),',','') name from t
2 group by idx;

IDX NAME
--------------------------------------- --------------------------------------------------------------------------------
1 ÎÒÊÇÉñÏÉ
2 ÎÒÊÇÉñÏÉ

SQL>

---

ÒýÓÃ

SQL code
SQL>select*from t;

                                    IDX NAME------