select FID , max(substr(sys_connect_by_path( FNAME, '+'), 2)) FNAME from (
select FID , FNAME, colc, lead(colc) over(partition by FID order by colc) cold from (
select FID , FNAME, row_number() over(order by FID , FNAME) colc from TABLE1) )
start with cold is null
connect by prior colc=cold
group by FID ;
select FID , FNAME, colc, lead(colc) over(partition by FID order by colc) cold from (
select FID , FNAME, row_number() over(order by FID , FNAME) colc from TABLE1) )
start with cold is null
connect by prior colc=cold
group by FID ;
解决方案 »
- Oracel能够把AL32UTF8编码的繁体字转换为Big5编码么?繁体站点注册的会员发送繁体电子邮件杂志,会员姓名是乱码,这个问题怎么解决?
- 大量数据库导入问题?
- Oracle Packages
- 为什么在客户端两台,同一时间只能有一台用ned assistant连上oracle服务器
- 各位大哥急救命 ,关于job死掉的问题 急急急 !!!!
- 一个和EXP有关的怪问题!都来看看!
- 请教ORACLE9i启动异常
- 请教一条SQL语句
- 关联更新 oracle
- 用insert语句插入数据序列自增为1,使用hibernate执行插入数据序列就变成2了
- oracle中数据文件包括什么?
- 用函数创建用户,还要加上连接和DBA权限,成功返回true,失败返回false。以及怎样调用?????
select fid,max(substr(sys_connect_by_path(fname,','),2)) fname from(
select fid,fname,row_number()over(order by fid,fname)+dense_rank(order by fid) as rn,
min(fname)over(partition by fid) as mi from view1)
start with fname=mi
connect by prior rn=rn-1;
group by fid
select fid,fname,row_number()over(order by fid,fname)+dense_rank()over(order by fid) as rn,
min(fname)over(partition by fid) as mi from view1)
start with fname=mi
connect by prior rn=rn-1;
group by fid
create view view1 as
select fid,max(substr(sys_connect_by_path(fname,','),2)) fname from(
select fid,fname,row_number()over(order by fid,fname)+dense_rank()over(order by fid) as rn,
min(fname)over(partition by fid) as mi from TABLE1)
start with fname=mi
connect by prior rn=rn-1;
group by fid