1.普通查询:select * from t_company_department
2.wmsys.wm_concat() 函数,合并到同一个字段:select wmsys.wm_concat(name) name from t_company_department
3.id与name字段合并:
select wmsys.wm_concat(id) ||'HelloWord'|| wmsys.wm_concat(name) name from t_company_department
1.普通查询:select * from t_company_department
2.wmsys.wm_concat() 函数,合并到同一个字段:select wmsys.wm_concat(name) name from t_company_department
3.id与name字段合并:
select wmsys.wm_concat(id) ||'HelloWord'|| wmsys.wm_concat(name) name from t_company_department