id name
1 a
2 就
3 是
4 嗯
5 cc
6 dd拼接结果为:
a,就,是,嗯,cc,dd
用逗号拼接起来
1 a
2 就
3 是
4 嗯
5 cc
6 dd拼接结果为:
a,就,是,嗯,cc,dd
用逗号拼接起来
解决方案 »
- 关于database link的高级问题,呵呵!
- 急、急、急,各位大虾,关于ORacle表只读权限问题
- 求助ORACLE SEQUENCE中,order选项的作用
- 关于xp系统共享上网
- 关于oracle exp/imp的问题
- 上海某外企诚聘Oracle顾问-----月薪10000RMB+
- 我机器上连接oracle过一会就会停掉,是什么原因?
- Oracle中二次查询的问题
- 求助!紧急啊~~查询字段为空的时候where条件略过,不为空时则判断该字段,怎么写!!! [问
- 新手求指导,触发器无法运行
- 有关IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
- lsnrctl stop 监听启动和停止都报错,数据库能正常打开 oracle11g linux
with t as (
select 1 as ismaster,'qingyun' as uname,'租赁' as state from dual union all
select 0 as ismaster,'aa' as uname,'租赁' as staet from dual union all
select 0 as ismaster,'aa' as uname,'空闲' as staet from dual
)
select wmsys.wm_concat(uname) from (select * from t where state='租赁' order by ismaster desc)
SELECT 1 id,'a' NAME FROM dual
UNION ALL
SELECT 2,'就' FROM dual
UNION ALL
SELECT 2,'是' FROM dual
UNION ALL
SELECT 2,'嗯' FROM dual
UNION ALL
SELECT 2,'cc' FROM dual
UNION ALL
SELECT 2,'dd' FROM dual)
SELECT wm_concat(name) FROM t