Declare sql server 转oracle语句 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) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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; 求语句 oracle process和sga有关系吗? 自动启动/关闭数据库 存储过程中含有ddl语句无法实现rollback吗? Oracle9i安装问题,高分求助,非常急! 怎么把一个普通表改为分区表? ★★★有关Oracle9i+Delphi7数据库的连接★★★ 问一下诸位,拿到OCP证书后每月大概能拿多少大洋? 紧急求救:在线等待! oracle存储过程 表空间扩展问题 从oracle数据库的一个表中一次要取出100万条数据,急需高手帮忙,麻烦说个原理或者给段示例代码出来
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;