我想統計當前User下所有table的記錄條數﹐在PL/SQL中
寫了下面一個procedure﹐但是編譯時提示:
cannot insert NULL into ("SYS"."OBJ$"."NAME")
不知是什么原因﹐能否指點下﹖
謝謝
create or replace procedure proc_count_recd
is
tablename varchar2(30);
row_num number := 0;
sql_str varchar2(200);
cursor cur_tablename is
select table_name from user_tables;
begin
delete from row_num_inTable;
open cur_tablename;
loop
fetch cur_tablename into tablename;
exit when cur_tablename%notfound;
sql_str := "select count(*) from "||tablename; //編譯時此行顯示黃色
execute immediate sql_str into row_num;
insert into row_num_inTable(table_name,row_count) values
(tablename,row_num);
sql_str := "";
end loop;
commit;
close cur_tablename;
end proc_count_recd;
寫了下面一個procedure﹐但是編譯時提示:
cannot insert NULL into ("SYS"."OBJ$"."NAME")
不知是什么原因﹐能否指點下﹖
謝謝
create or replace procedure proc_count_recd
is
tablename varchar2(30);
row_num number := 0;
sql_str varchar2(200);
cursor cur_tablename is
select table_name from user_tables;
begin
delete from row_num_inTable;
open cur_tablename;
loop
fetch cur_tablename into tablename;
exit when cur_tablename%notfound;
sql_str := "select count(*) from "||tablename; //編譯時此行顯示黃色
execute immediate sql_str into row_num;
insert into row_num_inTable(table_name,row_count) values
(tablename,row_num);
sql_str := "";
end loop;
commit;
close cur_tablename;
end proc_count_recd;
sql_str := 'select count(*) from '||tablename;
>>sql_str := "";
sql_str := '';