oracle存儲過程select?
.....
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;
....
希望能幫到你
oracle存儲過程select?
.....
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;
....
希望能幫到你