直接上图了,实际就是一个路由的查询,路由id为唯一标识(如1001),但一条路由可能有好几段(2段,3段,也可能十几段,)连接构成。现能查出路由的所有段,求把这些连接起来,在一行记录中显示。用的是pl/sql 环境多行变一行行数不定
解决方案 »
- oracle多个相同结构表查询一个结果集
- Windows 7 怎样安装Oracle
- select insert 超慢,不知慢在哪里?求高手指点
- 在winXP中安装oracle8.15的问题
- oracle92和ghost冲突,请高手指点
- ORACLE存储过程中怎样访问其他用户的表
- 请教高手:表空间、分区、分区表三者的关系是什么?要建立一分区表是否需首先建立分区?请祥述!
- 有没有把mssql的存储过程转换为oracle存储过程的工具?
- ???紧急求援,关于数据表中数据导出的问题???
- sqlplus无法处理服务名
- 大四毕业学数据库oracle怎么说?IT之路走不走了?
- oracle修改已有数据的列类型
但是我对 函数,过程等还非常不熟悉,求坛中各路大侠出出招啊。
within group(order by empno desc)
from emp;结果:
GROUP BY id
竟然忘记wm_concat这个列转换的函数了
with t as
(select 1 as id ,0 as value from dual
union all
select 1 as id ,2 as value from dual
union all
select 1 as id ,1 as value from dual
union all
select 1 as id ,3 as value from dual
union all
select 2 as id ,0 as value from dual
union all
select 2 as id ,2 as value from dual
union all
select 2 as id ,1 as value from dual
union all
select 2 as id ,3 as value from dual)
select id ,max (result_list) as result
from (select id,wm_concat(value) over (partition by id order by value) as result_list from t) group by id