declare
i number;
str varchar2(50);
cursor gettab is select table_name from user_tables;
begin
for v_gettab in gettab loop
str:='select count(1) from '||v_gettab.table_name;
execute immediate str into i;
dbms_output.output_line(i);
dbms_output.output_line(v_gettab.table_name);
end loop;
end;
/
i number;
str varchar2(50);
cursor gettab is select table_name from user_tables;
begin
for v_gettab in gettab loop
str:='select count(1) from '||v_gettab.table_name;
execute immediate str into i;
dbms_output.output_line(i);
dbms_output.output_line(v_gettab.table_name);
end loop;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货