摘要：
所有版本的oracle都可以使用select wm_concat(name) as name from user; 但如果是oracle11g，使用select listagg(name, ',') within group( order by name) as name from user;效率更... 阅读全文
摘要：
ID NUMBER1 137xxxx,138xxxx取出来成ID NUMBER1 137xxxx1 138xxxxcreatetabletest(idint,phonevarchar2(200));insertintotestvalues(1,'13811... 阅读全文