求SQL SELECT VC_CODE FROM TCODES WHERE VC_CODENO = '0001'结果是这样的:VC_CODE-------100120013001如果何用一条查询语句得到以下结果:VC_CODE--------------1001,2001,3001 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 10g以上的话SELECT wmsys.wm_concat(VC_CODE) FROM TCODES WHERE VC_CODENO = '0001'; select industry, sys_connect_by_path(industry, ',') from (select * ,rownum rn from t ) start with rn = 1connect by rn-1 = prior rn;9i的,楼主对照考下 select ltrim(sys_connect_by_path(VC_CODE, ','), ',') --去掉首尾的, from (SELECT VC_CODE, rownum rn FROM TCODES WHERE VC_CODENO = '0001') start with rn = 1connect by rn - 1 = prior rn;改进了下 4楼的9i、10g及以上版本都能通过,我写的要10g以上才行 select max(ltrim(sys_connect_by_path(VC_CODE, ','), ',')) --去掉首尾的, from (SELECT VC_CODE, rownum rn FROM TCODES WHERE VC_CODENO = '0001') start with rn = 1connect by rn - 1 = prior rn; 请问两个异常名称的区别 请问Case when用法`Oracle 求SOL写法并优化之(数据行较多) 请教: 仅更新一百多万条数据,需要十几二十分钟。请教名位。 如何从数据库中导出BLOB类型的记录?? 菜鸟问题,简单! 新手求助。 关于创建数据库链接的问题 oracle815 下如何用dbms_job 包来定时运行一个外部程序(例如 notepad) ? 求oracle里游标的使用,返回类型是临时表 or和rownum同时使用的索引问题
SELECT wmsys.wm_concat(VC_CODE) FROM TCODES WHERE VC_CODENO = '0001';
from (select * ,rownum rn
from t
)
start with rn = 1
connect by rn-1 = prior rn;
9i的,楼主对照考下
from (SELECT VC_CODE, rownum rn FROM TCODES WHERE VC_CODENO = '0001')
start with rn = 1
connect by rn - 1 = prior rn;
改进了下
from (SELECT VC_CODE, rownum rn FROM TCODES WHERE VC_CODENO = '0001')
start with rn = 1
connect by rn - 1 = prior rn;