Procedure of oracle (proc_count_recd)
来源:互联网 发布:fabric网络是什么意思 编辑:程序博客网 时间:2024/05/16 00:42
CREATE OR REPLACE PROCEDURE proc_count_recd
is
tablename varchar2(30);
rownum 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 rownum;
dbms_output.put_line(tablename||','||rownum);
insert into row_num_inTable(table_name,row_num,dbname) values
(tablename,rownum,'NEWMES');
sql_str := '';
end loop;
commit;
close cur_tablename;
end proc_count_recd;
is
tablename varchar2(30);
rownum 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 rownum;
dbms_output.put_line(tablename||','||rownum);
insert into row_num_inTable(table_name,row_num,dbname) values
(tablename,rownum,'NEWMES');
sql_str := '';
end loop;
commit;
close cur_tablename;
end proc_count_recd;
- Procedure of oracle (proc_count_recd)
- Usage of Cursor in Oracle Procedure
- oracle procedure
- ORACLE procedure
- oracle procedure
- oracle procedure
- oracle procedure
- oracle PROCEDURE
- oracle procedure
- ORACLE PROCEDURE
- oracle procedure
- oracle PROCEDURE
- oracle PROCEDURE
- oracle PROCEDURE
- Procedure of gen_udp:open
- 关于 procedure of object
- Oracle Procedure and Function
- oracle procedure and webservice
- 优秀js开源框架-jQuery使用手册(1)
- 深入剖析WTL—WTL框架窗口分析(3)
- JS 屏幕 分辨率 大小
- 理解SWT布局
- 比较两个文件是否相同
- Procedure of oracle (proc_count_recd)
- Tree控件的方法
- 深入剖析WTL—WTL框架窗口分析(4)
- 3.3 [ Enterprise Library ]设计时配置
- 小婵设计的一个blog摸板
- 深入剖析WTL—WTL框架窗口分析(2)
- 转:《Effective C#》Item 8:确保“0”在值类型中是有效的
- VCKBase_50_篇2:Unicode
- 深入剖析WTL—WTL框架窗口分析(1)