求教一个sql写法
在sqlsever里可以这么写：
declare @look nvarchar(1024)
set @look = ''
select @look = @look + sysobjects.name from sysobjects
select @look


可以在oracle中想实现类似功能怎么写呢？求教！

------解决方案--------------------

SQL code

set serveroutput on;
declare 
  look varchar2(1024) := '';
begin
  select wmsys.wm_concat(name) into look from sysobjects;
  dbms_output.put_line();
end;