WMSYS.WM_CONCAT函数

最新推荐文章于 2021-04-15 04:37:38 发布

潇水汀寒

最新推荐文章于 2021-04-15 04:37:38 发布

阅读量1k

点赞数

分类专栏：以前的文章标签： microsoft sql database oracle windows

本文链接：https://blog.csdn.net/lucien_zong/article/details/7842013

版权

以前的专栏收录该内容

10 篇文章 0 订阅

订阅专栏

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\e>sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on 星期三 8月 8 09:52:46 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

请输入用户名:  sys as sysdba
输入口令:

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select snap_id,undoblks from wrh$_undostat
  2  where snap_id <= 118 order by snap_id;

   SNAP_ID   UNDOBLKS
---------- ----------
       114        433
       114         15
       114         14
       114         12
       114         61
       115         15
       115         13
       115         13
       115         15
       115         91
       115         11

   SNAP_ID   UNDOBLKS
---------- ----------
       116         15
       116         13
       116         16
       116         12
       116         71
       117         18
       118         17
       118         71
       118         10
       118         15
       118         15

   SNAP_ID   UNDOBLKS
---------- ----------
       118          9

已选择23行。

SQL> select snap_id,WMSYS.WM_CONCAT(undoblks)
  2  from wrh$_undostat where snap_id <= 118
  3  group by snap_id;

   SNAP_ID
----------
WMSYS.WM_CONCAT(UNDOBLKS)
--------------------------------------------------------------------------------

       114
61,433,14,15,12

       115
91,15,13,15,11,13

       116
71,13,15,12,16


   SNAP_ID
----------
WMSYS.WM_CONCAT(UNDOBLKS)
--------------------------------------------------------------------------------

       117
18

       118
71,17,15,15,9,10


SQL> col WMSYS.WM_CONCAT(UNDOBLKS) for a30;
SQL> select snap_id,WMSYS.WM_CONCAT(undoblks)
  2  from wrh$_undostat where snap_id <= 118
  3  group by snap_id;

   SNAP_ID WMSYS.WM_CONCAT(UNDOBLKS)
---------- ------------------------------
       114 61,433,14,15,12
       115 91,15,13,15,11,13
       116 71,13,15,12,16
       117 18
       118 71,17,15,15,9,10

SQL> select version from v$instance;

VERSION
-----------------
10.2.0.3.0

SQL>