Oracle 10 Gb obtains the result set for merging values in column B based on the same values in column.

Oracle 10g obtains the result set of merging values in column B based on the same value in column a. oracle 10g obtains the same value according to Column, obtains the result set that combines values in column B. (Make a and B form a parent-child relationship) www.2cto.com -- source table table_t a B Guangdong Guangzhou Guangdong Shenzhen Guangxi Nanning Guangxi Beihai -- SQL select a, WMSYS. WM_CONCAT (B) B from table_t group by a -- result table a B Guangdong Guangzhou, Shenzhen Guangxi Nanning, Beihai --------- Note: it is for reference only and can be expanded freely, hope to help people in need.