{"id":1582,"date":"2013-03-12T16:09:55","date_gmt":"2013-03-12T07:09:55","guid":{"rendered":"http:\/\/lovely-moon.com\/blog\/?p=1582"},"modified":"2015-08-11T09:35:30","modified_gmt":"2015-08-11T00:35:30","slug":"%e5%82%99%e5%bf%98%e9%8c%b2-%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e6%93%8d%e4%bd%9c%ef%bc%88oracle%ef%bc%89","status":"publish","type":"post","link":"https:\/\/lovely-moon.com\/blog\/?p=1582","title":{"rendered":"\u5099\u5fd8\u9332 \u30c6\u30fc\u30d6\u30eb\u64cd\u4f5c (Oracle)"},"content":{"rendered":"<h4><span style=\"color: #a52a2a;\">\uff3b\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\uff3d<\/span><\/h4>\n<h4>\u81ea\u5206\u304c\u6240\u6709\u3059\u308b\u30c6\u30fc\u30d6\u30eb<\/h4>\n<ul>\n<li>SQL&gt; select table_name from user_tables;<\/li>\n<\/ul>\n<h4>\u81ea\u5206\u304c\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u30c6\u30fc\u30d6\u30eb<\/h4>\n<ul>\n<li>SQL&gt; select table_name from all_tables;<\/li>\n<\/ul>\n<\/ul>\n<h4><span style=\"color: #a52a2a;\">\uff3b\u30c6\u30fc\u30d6\u30eb\u6240\u6709\u8005\u4e00\u89a7\uff3d<\/span><\/h4>\n<ul>\n<li>SQL&gt; select owner,table_name from all_tables;<\/li>\n<\/ul>\n<h4><span style=\"color: #a52a2a;\">\uff3b\u30c7\u30fc\u30bf\u4ef6\u6570\u306e\u30ab\u30a6\u30f3\u30c8\uff3d<\/span><\/h4>\n<ul>\n<li>SQL&gt; select count(*) from \u30c6\u30fc\u30d6\u30eb\u6240\u6709\u8005.\u30c6\u30fc\u30d6\u30eb;<\/li>\n<\/ul>\n<p><!-- Ads --> <script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- Ads --> <!-- Advertising-Rectangle --><br \/>\n<!-- Ads --> <ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px\" data-ad-client=\"ca-pub-0658343697312886\" data-ad-slot=\"8784431573\"><\/ins><br \/>\n<!-- Ads --> <script>(adsbygoogle = window.adsbygoogle || []).push({});<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uff3b\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\uff3d \u81ea\u5206\u304c\u6240\u6709\u3059\u308b\u30c6\u30fc\u30d6\u30eb SQL&gt; select table_name from user_tables; \u81ea\u5206\u304c\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u30c6\u30fc\u30d6\u30eb SQL&gt; select table_name from &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/lovely-moon.com\/blog\/?p=1582\"> <span class=\"screen-reader-text\">\u5099\u5fd8\u9332 \u30c6\u30fc\u30d6\u30eb\u64cd\u4f5c (Oracle)<\/span> \u7d9a\u304d\u3092\u8aad\u3080 &raquo;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[8],"class_list":["post-1582","post","type-post","status-publish","format-standard","hentry","category-3","tag-memorandum"],"_links":{"self":[{"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1582"}],"version-history":[{"count":9,"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1582\/revisions"}],"predecessor-version":[{"id":3587,"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1582\/revisions\/3587"}],"wp:attachment":[{"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lovely-moon.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}