{"id":907,"date":"2013-07-01T15:14:21","date_gmt":"2013-07-01T07:14:21","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=907"},"modified":"2013-07-01T15:15:17","modified_gmt":"2013-07-01T07:15:17","slug":"scripts%ef%bc%9a%e7%bb%9f%e8%ae%a1%e6%8c%87%e5%ae%9a%e7%94%a8%e6%88%b7%e4%b8%8b%e6%89%80%e6%9c%89%e8%a1%a8%e7%9a%84%e6%80%bb%e6%9d%a1%e6%95%b0","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=907","title":{"rendered":"scripts\uff1a\u7edf\u8ba1\u6307\u5b9a\u7528\u6237\u4e0b\u6240\u6709\u8868\u7684\u603b\u6761\u6570"},"content":{"rendered":"<p><strong>\u7528\u9014\uff1a<br \/>\n\u7edf\u8ba1\u6307\u5b9a\u7528\u6237\u4e0b\u6240\u6709\u8868\u7684\u603b\u6761\u6570\u5e76\u5206\u5217\u5355\u8868\u6761\u6570\uff08\u5b9e\u9645\u7684\u603b\u6761\u6570\u975e\u7edf\u8ba1\u4fe1\u606f\u4e2d\u7684\u6761\u6570\uff09\u4ee5\u4f9b\u7edf\u8ba1\u4e4b\u7528\u3002<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nset serverout on\r\ndeclare \r\nv_sum_num number :=0;\r\nv_num number :=0;\r\nv_table_name varchar2(100);\r\nstr_sql varchar2(500);\r\ncursor tab_name is select table_name from dba_tables where owner= upper(&#039;&amp;user_name&#039;) order by 1;\r\nbegin\r\n\tdbms_output.put_line(&#039;---------TABLE SUM------------&#039;);\r\n\tfor i in tab_name\r\n\t\tloop\r\n\t\t\tv_table_name:=i.table_name;\r\n\t\t\texecute immediate &#039;select count(*) from &#039; || v_table_name into v_num;\r\n\t\t\tdbms_output.put_line(v_table_name||&#039;:&#039;||v_num);\r\n\t\t\tv_sum_num:=v_num+v_sum_num;\r\n\t\tend loop;\r\n\tdbms_output.put_line(&#039;------------------------------&#039;);\r\n\tdbms_output.put_line(&#039;SUM_NUM:&#039;||v_sum_num);\r\nend;\r\n\r\n<\/pre>\n<p><strong>\u8f93\u51fa\u793a\u4f8b\u5982\u4e0b\uff1a<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; set serverout on\r\nSQL&gt; declare \r\n  2  v_sum_num number :=0;\r\n  3  v_num number :=0;\r\n  4  v_table_name varchar2(100);\r\n  5  str_sql varchar2(500);\r\n  6  cursor tab_name is select table_name from dba_tables where owner= upper(&#039;&amp;user_name&#039;) order by 1;\r\n  7  begin\r\n        dbms_output.put_line(&#039;---------TABLE SUM------------&#039;);\r\n  8    9        for i in tab_name\r\n 10             loop\r\n 11                     v_table_name:=i.table_name;\r\n 12                     execute immediate &#039;select count(*) from &#039; || v_table_name into v_num;\r\n 13                     dbms_output.put_line(v_table_name||&#039;:&#039;||v_num);\r\n 14                     v_sum_num:=v_num+v_sum_num;\r\n 15             end loop;\r\n 16     dbms_output.put_line(&#039;------------------------------&#039;);\r\n 17     dbms_output.put_line(&#039;SUM_NUM:&#039;||v_sum_num);\r\n 18  end;\r\n 19  \/\r\nEnter value for user_name: test\r\nold   6: cursor tab_name is select table_name from dba_tables where owner= upper(&#039;&amp;user_name&#039;) order by 1;\r\nnew   6: cursor tab_name is select table_name from dba_tables where owner= upper(&#039;test&#039;) order by 1;\r\n---------TABLE SUM------------\r\nTABLE1:2770\r\nTABLE2:5092\r\n------------------------------\r\nSUM_NUM:7862\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\n\r\n\r\nSQL&gt; select table_name from user_tables;\r\n\r\nTABLE_NAME\r\n------------------------------\r\nTABLE2\r\nTABLE1\r\n\t\r\nSQL&gt; select count(*) from table1;\r\n\r\n  COUNT(*)\r\n----------\r\n      2770\r\n\r\nSQL&gt; select count(*) from table2;\r\n\r\n  COUNT(*)\r\n----------\r\n      5092\r\n\r\nSQL&gt; select 2770+5092 from dual;\r\n\r\n 2770+5092\r\n----------\r\n      7862\t\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u7528\u9014\uff1a \u7edf\u8ba1\u6307\u5b9a\u7528\u6237\u4e0b\u6240\u6709\u8868\u7684\u603b\u6761\u6570\u5e76\u5206\u5217\u5355\u8868\u6761\u6570\uff08\u5b9e\u9645\u7684\u603b\u6761\u6570\u975e\u7edf\u8ba1\u4fe1\u606f\u4e2d\u7684\u6761\u6570\uff09\u4ee5\u4f9b\u7edf\u8ba1\u4e4b\u7528\u3002 set s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[208,209,210],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/907"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=907"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/907\/revisions"}],"predecessor-version":[{"id":909,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/907\/revisions\/909"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=907"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}