轉:10g新增功能實現字串連線

10g新增功能實現字串連線

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> DESC WMSYS.WM_CONCAT
FUNCTION WMSYS.WM_CONCAT RETURNS VARCHAR2引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
P1 VARCHAR2 IN

SQL> SELECT WMSYS.WM_CONCAT(TNAME) FROM TAB;

WMSYS.WM_CONCAT(TNAME)
-------------------------------------------------------------------------------------------
T_PARTITION,T_PART,CHAINED_ROWS,T_NO_EXISTS_BEFORE,T_CHAR,T_LOAD_SPACE,T_LEVEL,T_LEVEL1,T_TREE,T_RECGTK,T_FUNCTION,T_TAB,T_SESSION_STAT,T_TEMP2,SYS_EXPORT_SCHEMA_01,MV_T,T_INDEX_ORG,T_PART_RANGE,C_TEST_256,T_NUM,MV_T_NUM,C_HASH,T_HASH,TEST,T_PART_INDEX,RUPD$_MV_T,MLOG$_MV_T,T_EXTERNAL2,T_EXTERNAL_LO_ERROR_LOG1,V_T,T1,T2

[@more@]