oracle wm_concat 用法
来源:互联网 发布:mdb数据库修复 编辑:程序博客网 时间:2024/06/05 17:42
<pre name="code" class="sql">with tmp_0042 as ( SELECT F003D_0042, F008V_0042,F007N_0042,F006B_0042,OB_RECTIME_0042,OB_TEXTID_0042,F002D_0042,F004V_0042 FROM TB_TEXT_0042 WHERE TO_CHAR(OB_RECTIME_0042, 'yyyy-MM-dd') = '2013-01-04' )--select * from tmp_0042SELECT D.*, E.F006B_0042FROM (SELECT F003D_0042,F008V_0042,F007N_0042,OB_RECTIME_0042,OB_TEXTID_0042,F002D_0042,F004V_0042,B.OB_SECCODE_0045,C.OB_SORTCODE_0043 FROM tmp_0042 A,(select OB_TEXTID_0045, WM_CONCAT(OB_SECCODE_0045) OB_SECCODE_0045 from TB_TEXT_0045 t0045, tmp_0042 t0042 where t0042.OB_TEXTID_0042=t0045.OB_TEXTID_0045 and F001V_0045 IN ('QDII','LOF','ETF','老基金','开放式基金','封闭式基金') group by OB_TEXTID_0045) B,(select OB_TEXTID_0043, WM_CONCAT(OB_SORTCODE_0043)OB_SORTCODE_0043 from TB_TEXT_0043 t0043, tmp_0042 t0042 where t0042.OB_TEXTID_0042=t0043.OB_TEXTID_0043 group by OB_TEXTID_0043) C WHERE A.OB_TEXTID_0042=B.OB_TEXTID_0045(+)AND A.OB_TEXTID_0042 =C.OB_TEXTID_0043(+) ) D,tmp_0042 E WHERE D.OB_TEXTID_0042 = E.OB_TEXTID_0042
0 0
- oracle wmsys.wm_concat用法
- oracle wm_concat (column) 用法
- oracle wm_concat函数用法
- oracle wm_concat 用法
- oracle with as 用法 和 wm_concat 用法
- oracle 的wmsys.wm_concat函数用法
- oracle 的wmsys.wm_concat函数用法
- oracle中函数wm_concat()用法
- Oracle wmsys.wm_concat的几个用法
- Oracle 函数 wmsys.wm_concat 的几个用法
- oracle行转列函数WMSYS.WM_CONCAT用法
- oracle 函数WMSYS.WM_CONCAT()的用法
- oracle wm_concat
- oracle wm_concat
- ORACLE wm_concat
- 关于WMSYS.WM_CONCAT函数的用法(oracle 10g)
- oracle关键字with..as和wm_concat的用法说明
- Oracle 函数 wm_concat 将列转行 用法 实例
- 解决mysql使用GTID主从复制错误问题
- POI导出EXCEL经典实现
- Android 系统稳定性
- Eclipse使用Maven创建Web时错误:Could not resolve archetype org.apache.maven.archetypes:maven-archetype-webap
- [C++]隐式类类型转换(转)
- oracle wm_concat 用法
- PyCharm+QT Designer整合
- Python——类的设计
- 双线性插值(Bilinear Interpolation)
- 解决在scrollview上下滑动嵌套scrollview,viewpager水平滑动时问题
- Mysql AB 复制
- 25、通用的ViewHolder
- git修改了本地代码想传到新的branch
- 26、微信聊天Fragment_Msg的界面布局