oracle

oracle数据合并列字段


select a.room_id, wmsys.wm_concat(a.item_code) item_code,

       wmsys.wm_concat(to_char(b.item_name)) item_name,     

       wmsys.wm_concat(b.item_type) item_type

from sf_item_manage a,sf_item b 

where a.item_code=b.item_code and  room_id='2013071113115642'

group by room_id