{"provider_url":"https://hatena.blog","blog_title":"\u306d\u3082\u3077\u3089\u3059","height":"190","published":"2009-02-02 22:00:52","author_url":"https://blog.hatena.ne.jp/yamazaru_rengou/","blog_url":"https://nemoplus.hateblo.jp/","width":"100%","type":"rich","categories":["Oracle","tips"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fnemoplus.hateblo.jp%2Fentry%2F20090202%2F1233579652\" title=\" \u5168\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u53d6\u5f97\u3059\u308b - \u306d\u3082\u3077\u3089\u3059\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","version":"1.0","title":" \u5168\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u53d6\u5f97\u3059\u308b","image_url":null,"author_name":"yamazaru_rengou","description":"http://forums.oracle.com/forums/thread.jspa?messageID=1794280#1794280 SELECT table_name, TO_NUMBER( EXTRACTVALUE( xmltype( dbms_xmlgen.getxml('SELECT COUNT(*) AS C FROM '||table_name) ), '/ROWSET/ROW/C' ) ) AS count FROM user_tables; \u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6d41\u308c\u3067\u5168\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066 SQL \u3092\u767a\u884c\u3067\u304d\u308b\u3002 user_tables \u304b\u3089\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3092\u53d6\u5f97\uff08SELECT tabl\u2026","url":"https://nemoplus.hateblo.jp/entry/20090202/1233579652"}