http://www.siue.edu/~dbock/cmis565/
Install oracle on Linux
http://www.dbanotes.net/Oracle/Install-Oracle10g-RHEL3.htm
Offical oracle documentation about dynamic SQL
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/executeimmediate_statement.htm
select t.station_group,
max(case when rownum =1 then station_id else null end) ||
max(case when rownum =2 then station_id else null end) ||
max(case when rownum =3 then station_id else null end) as station_id
from (select rs.station_group,rs.station_id from routing_station rs
where rownum <=3 order by 1 desc) t group by t.station_group
select t.station_group,
max(case when rownum =1 then station_id else null end) as station_id_1,
max(case when rownum =2 then station_id else null end) as station_id_2,
max(case when rownum =3 then station_id else null end) as station_id_3
from (select rs.station_group,rs.station_id from routing_station rs
where rownum <=3 order by 1 desc) t group by t.station_group
select station_group,substr(sys_connect_by_path(station_id, ','),2) station_id
from (
select rs.station_id,rs.station_group, count(1) over(partition by rs.station_group) cnt,
row_number() over(partition by rs.station_group order by 1) seq from routing_station rs
)
where seq=cnt start with seq=1
connect by prior seq+1=seq
and prior station_group=station_group
分享到:
相关推荐
oracle 9i study guide,007,031,032,033
linux study ,it my study document.
Quartus2_Study_Document
Introduction to Oracle9i SQL Study Guide
sybex_OCA&OCP Introduction to Oracle9i SQL Study Guide.pdf
OCP-007 Introduction to Oracle 9i SQL Study Guide.pdf
GoldenGate Case Study
This introduces many sentences of english in business situation.
ORACLE RAC INSTALL STUDY.docx
这是个示例:一步步在Oracle BI Server中创建Model. 英文的。不过图文并茂,所以看起来不难。 另外请关注:Oracle BI Answer Study - Step by step
It built on a previous study which identified eight website evaluation criteria related to biological sex: collaboration, social connectivity, flexibility, motility, con-textuality, personal ...
Oracle笔记study163 (笔记手打,做到20讲子查询)
oracle, database,数据库,最新12c,认证考试,英文资料好不容易得到
sybex OCP Oracle9i DBA FundamentalsII Study Guide
oracle transpotation managerment document for study
OCP:Oracle 10g Administration II Study Guide <br>中文译名: OCP:Oracle 10g管理II学习指南(1Z0-043) <br> 【原出版社】 Sybex 【作 者】(美)Doug Stuns,Tim Buterbaugh,Bob Bryla ...
OCP Introduction to Oracle 9i SQL Study Guide
Oracle_SQL_PLSQL Study Guide.rar