declare tablea varchar2(100);
declare sql_statement varchar2(200);tablea:=str1||str2;
sql_statement: = 'select count(*) counta from ' + tablea
execute immediate sql_statement;--这里的tablea就是变量了
declare sql_statement varchar2(200);tablea:=str1||str2;
sql_statement: = 'select count(*) counta from ' + tablea
execute immediate sql_statement;--这里的tablea就是变量了
tablea varchar2(100);
str varchar2(50);
tablea:=str1||str2;
begin
str:='select count(*) from '||tablea;--这里的tablea就是变量了
execute immediate str into counta;
if counta=1 then
....
else
...
end if;
end;
/
我需要的是在counta中得到count(*),这样的sql可以吗?
马上给分