…..
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;
….
希望能帮到你
时间:2023-02-09 03:06:33
…..
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;
….
希望能帮到你