把结果集连接成字符串? 用user_tables举一个例子吧。例如:结果集为 select table_name from user_tables 将其转换成一个长串。 select SYS_CONNECT_BY_PATH(table_name, '#') from ( select lag(rnum,1,0) over(order by rnum) as lrnum,rnum,table_name from ( select rownum as rnum,table_name from user_tables ) ) where level=(select count(*) from user_tables) connect by rnum=prior lrnum 以上供参考
SQL> select wmsys.wm_concat(tablespace_name) from user_tablespaces;WMSYS.WM_CONCAT(TABLESPACE_NAM -------------------------------------------------------------------------------- SYSTEM,UNDOTBS1,SYSAUX,TEMP,USERS,EXAMPLE,TEST_SP,ZFTANG_DB,ZFTANG_IDX,TABSPACE_SQL>
用user_tables举一个例子吧。例如:结果集为 select table_name from user_tables
将其转换成一个长串。
select SYS_CONNECT_BY_PATH(table_name, '#') from (
select lag(rnum,1,0) over(order by rnum) as lrnum,rnum,table_name from (
select rownum as rnum,table_name from user_tables ) )
where level=(select count(*) from user_tables)
connect by rnum=prior lrnum
以上供参考
--------------------------------------------------------------------------------
SYSTEM,UNDOTBS1,SYSAUX,TEMP,USERS,EXAMPLE,TEST_SP,ZFTANG_DB,ZFTANG_IDX,TABSPACE_SQL>