在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;