Declare
str varchar2(100);
record number;
begin
str:='select count(*) from bookinfo';
execute immediate str;
end ;上面是正确执行 且不会抱错Declare
str varchar2(100);
record number;
begin
str:='select count(*) into '||record||' from bookinfo';
execute immediate str;
end ;但下面的却 抱 一个 缺少表达式 的错误 ?.....
str varchar2(100);
record number;
begin
str:='select count(*) from bookinfo';
execute immediate str;
end ;上面是正确执行 且不会抱错Declare
str varchar2(100);
record number;
begin
str:='select count(*) into '||record||' from bookinfo';
execute immediate str;
end ;但下面的却 抱 一个 缺少表达式 的错误 ?.....
str varchar2(100);
record number;
begin
str:='select count(*) from bookinfo';
execute immediate str into record;
end ;