求一oracle对应的语句

[zhuqide]

sql server 存储过程中的语句：
SET @recordCountSql = 'select @count = count(*) from '+ @TableName + ' as SQL'
EXEC sp_executesql @recordCountSql, N'@count varchar(20) output', @count output


求oracle版

[lee24]

sp_executesql这个是什么，一个函数吗？

@recordCountSql = 'select @count = count(*) from '+ @TableName + ' as SQL'
变成：
recordCountSql := 'select count(*) into ' || count || ' from ' || TableName;

然后再执行你自己的这个sp_executesql

[阿三]

SQL> declare
2 aa varchar2(200);
3 begin
4 aa := 'aaaa';
5 exec 存储过程名(aa);
6 end;

类似这样

如果是动态SQL
execute 动态SQL;