在sqlsever里可以这么写:
declare @look nvarchar(1024)
set @look = ''
select @look = @look + sysobjects.name from sysobjects
select @look
可以在oracle中想实现类似功能怎么写呢?求教!
declare @look nvarchar(1024)
set @look = ''
select @look = @look + sysobjects.name from sysobjects
select @look
可以在oracle中想实现类似功能怎么写呢?求教!
declare
look varchar2(1024) := '';
begin
select wmsys.wm_concat(name) into look from sysobjects;
dbms_output.put_line();
end;