…..
tbl_name varchar2(100); ——–tal_name 是存放表名的变量
a_num number;
…….
tbl_name:=xxxxxx;
a_num:=0;
….
execute immediate ‘ select count(1) from ‘||tbl_name into a_num;
……
end;
….
希望能帮到你
时间:2021-07-31 04:39:32
…..
tbl_name varchar2(100); ——–tal_name 是存放表名的变量
a_num number;
…….
tbl_name:=xxxxxx;
a_num:=0;
….
execute immediate ‘ select count(1) from ‘||tbl_name into a_num;
……
end;
….
希望能帮到你