oracle11g 列转行样例
来源:互联网 发布:c语言购物卡制卡系统 编辑:程序博客网 时间:2024/05/29 18:37
declare
sqlstr varchar2(8000) := '';
begin
select WM_CONCAT(''''||acct_period||'''') into sqlstr
from (
SELECT acct_period FROM a5_mobile_account t where acct_period>=201703 GROUP BY acct_period
) t;
sqlstr:='SELECT * FROM (SELECT acct_period,credit FROM a5_mobile_account )
PIVOT (
SUM(credit) FOR acct_period
IN ('||sqlstr||')
) ORDER BY 1';
execute immediate sqlstr;
sqlstr := 'CREATE OR REPLACE VIEW tmp_result AS '|| sqlstr;
execute immediate sqlstr;
end;
select * from tmp_result
sqlstr varchar2(8000) := '';
begin
select WM_CONCAT(''''||acct_period||'''') into sqlstr
from (
SELECT acct_period FROM a5_mobile_account t where acct_period>=201703 GROUP BY acct_period
) t;
sqlstr:='SELECT * FROM (SELECT acct_period,credit FROM a5_mobile_account )
PIVOT (
SUM(credit) FOR acct_period
IN ('||sqlstr||')
) ORDER BY 1';
execute immediate sqlstr;
sqlstr := 'CREATE OR REPLACE VIEW tmp_result AS '|| sqlstr;
execute immediate sqlstr;
end;
select * from tmp_result
0 0
- oracle11g 列转行样例
- 列转行
- 列转行
- 列转行
- 列转行
- 列转行
- 列转行
- 列转行
- 列转行
- 列转行
- sql列转行
- sql列转行
- 列转行SQL
- Sqlserver 列转行
- sql列转行
- sql列转行
- SQL 列转行
- 列转行、行转列
- BaseRecyclerViewAdapterHelper开源项目之BaseSectionQuickAdapter 实现分组效果的源码学习
- 阿里云 CentOS 6.5 32位 nginx 安装
- Python求两个list的差集、交集与并集的方法(转)
- 汇编指令
- jquery计时器
- oracle11g 列转行样例
- Android动画专题之补间动画
- 记一次失败的搜狐前端面试
- Oracle,mysql,sqlServer分页
- Ionic Js的导航和内容
- PASCAL VOC2012 Chanllge 及其Dataset介绍
- 关于通过屏幕旋转确定view的layout的问题
- ubuntu 16.04下搜狗输入法不能输入中文解决(linux下常见软件崩溃问题解决方案)
- appstore 审核因为PLA1.2被拒的问题