sql server 存储过程中的语句:
SET @recordCountSql = 'select @count = count(*) from '+ @TableName + ' as SQL'
EXEC sp_executesql @recordCountSql, N'@count varchar(20) output', @count output
求oracle版
SET @recordCountSql = 'select @count = count(*) from '+ @TableName + ' as SQL'
EXEC sp_executesql @recordCountSql, N'@count varchar(20) output', @count output
求oracle版
2 aa varchar2(200);
3 begin
4 aa := 'aaaa';
5 exec 存储过程名(aa);
6 end;类似这样如果是动态SQL
execute 动态SQL;
变成:
recordCountSql := 'select count(*) into ' || count || ' from ' || TableName;然后再执行你自己的这个sp_executesql