select A1,A2, b1,b2 from (select '01' as A1, 'a' as A2, '1' as A3, 'x' as a4, '12' as A5 from dual UNION all select '01' as A1, 'a' as A2, '2' as A3, 'z' as a4, '23' as A5 from dual UNION all select '01' as A1, 'b' as A2, '1' as A3, 'x' as a4, '34' as A5 from dual UNION all select '01' as A1, 'b' as A2, '2' as A3, 'z' as a4, '45' as A5 from dual UNION all select '02' as A1, 'c' as A2, '1' as A3, 'x' as a4, '56' as A5 from dual UNION all select '02' as A1, 'c' as A2, '2' as A3, 'z' as a4, '67' as A5 from dual UNION all select '02' as A1, 'd' as A2, '1' as A3, 'x' as a4, '78' as A5 from dual UNION all select '02' as A1, 'd' as A2, '2' as A3, 'z' as a4, '89' as A5 from dual ) t model RETURN UPDATED ROWS --只返回被更新的行 partition by(A1,A2) --按照A1,A2分组 dimension by(A3,A4) --以A3,A4为标尺 measures( A5 as b1, --初始化新列b1,为了保证b1的长度,以A5进行初始化 A5 as b2, --初始化新列b2 A5 as b5 ) rules( b1[null,null]=b5['1','x'], --[null,null]表示不更新任何行,而追加一行,用所给A3,A4值查找对应的A5的值 b2[null,null]=b5['2','z'] );
相关推荐
oracle行转列
oracle 行转列的sql语句写法, 附带例子
Oracle行转列
oracle行转列_列转行,实例加解析,自己测试没问题。免费分享了~
NULL 博文链接:https://13966692733-163-com.iteye.com/blog/1192434
NULL 博文链接:https://vernonchen163.iteye.com/blog/1902976
数据库查询中难免会遇到行列转换的情况,摘列一些较精典的解决方案
行转列函数,对于学习sql查询的朋友们,可能会遇到这样的要求,此文档中做了详细记载,希望可以帮到你!
用存储过程写的动态行转列。简单易用,查询速度高效
许多情况下,由于程序中需要将行转为列展示,如果使用ORACLE那么这个资源适合你。
oracle数据库最详细的行转列资料,是官方文档的详细介绍版,中文的
关于oracle数据库如何行转列SQL语句。
oracle实现行转列功能,并使用逗号进行隔开拼接,成为一条数据.pdf
SQL行转列问题,有实例,根据具体实例讲解,清晰易懂。 希望对你有帮助!
理解日常工作中常用到的多列分组, 如【统计不同部门、 不同职位的平均工资】和 行转列 包含例子 和 个人理解分析
Oracle中使用语句将行数据转换称不同的列表示,或者将不同的列数据写到同一列的不同行上的行列转换问题是一个非常传统的话题。 网络上流传了很多将行数据转换称列数据的方法和应用实例,一般通过decode或者case函数...
oracle知识列点 一个简单的行列转换例子,需要的可以看下