3,491
社区成员
发帖
与我相关
我的任务
分享
Declare @sql varchar(8000)
Set @sql = 'select '
Select @sql = @sql + Subject+','
from (select distinct Subject from cj) as cj
Set @sql=SubString(@sql,1,len(@sql)-1)
Select @sql = @sql+' from table3'
Exec (@sql)
declare
tsql varchar2(8000);
begin
tsql := ' select ';
select (tsql || Subject || ',') into tsql from (select distinct Subject from cj) as cj;
tsql := substr(tsql,1,Length(tsql)-1);
tsql := tsql || ' from table3';
execute immediate tsql;
end;
declare
tsql varchar2(8000);
begin
tsql := ' select ';
select (tsql || Subject || ',') into tsql from (select distinct Subject from cj) as cj;
tsql := substr(tsql,1,Length(tsql)-1);
tsql := tsql || ' from table3';
execute immediate tsql;
end;