{"id":308117,"date":"2024-01-18T23:53:50","date_gmt":"2024-01-18T15:53:50","guid":{"rendered":"https:\/\/www.idc.net\/help\/308117\/"},"modified":"2024-01-18T23:53:50","modified_gmt":"2024-01-18T15:53:50","slug":"oracle%e6%9f%a5%e8%af%a2%e7%94%a8%e6%88%b7%e6%89%80%e6%9c%89%e8%a1%a8%e7%9a%84%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/idc.net\/help\/308117\/","title":{"rendered":"oracle\u67e5\u8be2\u7528\u6237\u6240\u6709\u8868\u7684\u8bed\u53e5"},"content":{"rendered":"<p>\u4e0b\u9762\u4e3a\u60a8\u4ecb\u7ecd\u7684\u8bed\u53e5\u7528\u4e8e\u5b9e\u73b0oracle\u67e5\u8be2\u7528\u6237\u6240\u6709\u8868\uff0c\u5982\u679c\u60a8\u5bf9oracle\u67e5\u8be2\u65b9\u9762\u611f\u5174\u8da3\u7684\u8bdd\uff0c\u4e0d\u59a8\u4e00\u770b\u3002<\/p>\n<p>select * from all_tab_comments <br \/> -- \u67e5\u8be2\u6240\u6709\u7528\u6237\u7684\u8868,\u89c6\u56fe\u7b49<\/p>\n<p>select * from user_tab_comments&nbsp;&nbsp; <br \/> -- \u67e5\u8be2\u672c\u7528\u6237\u7684\u8868,\u89c6\u56fe\u7b49<\/p>\n<p>select * from all_col_comments <br \/> --\u67e5\u8be2\u6240\u6709\u7528\u6237\u7684\u8868\u7684\u5217\u540d\u548c\u6ce8\u91ca.<\/p>\n<p>select * from user_col_comments <br \/> -- \u67e5\u8be2\u672c\u7528\u6237\u7684\u8868\u7684\u5217\u540d\u548c\u6ce8\u91ca<\/p>\n<p>select * from all_tab_columns <br \/> --\u67e5\u8be2\u6240\u6709\u7528\u6237\u7684\u8868\u7684\u5217\u540d\u7b49\u4fe1\u606f(\u8be6\u7ec6\u4f46\u662f\u6ca1\u6709\u5907\u6ce8).<\/p>\n<p>select * from user_tab_columns <br \/> --\u67e5\u8be2\u672c\u7528\u6237\u7684\u8868\u7684\u5217\u540d\u7b49\u4fe1\u606f(\u8be6\u7ec6\u4f46\u662f\u6ca1\u6709\u5907\u6ce8).<\/p>\n<p>--\u4e00\u822c\u4f7f\u75281:<br \/> select t.table_name,t.comments from user_tab_comments t<\/p>\n<p>--\u4e00\u822c\u4f7f\u75282:<br \/> select r1, r2, r3, r5<br \/> from (select a.table_name r1, a.column_name r2, a.comments r3<br \/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from user_col_comments a),<br \/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (select t.table_name r4, t.comments r5 from user_tab_comments t)<br \/> where r4 = r1<\/p>\n<p>\u4ee5\u4e0a\u5c31\u662foracle\u67e5\u8be2\u7528\u6237\u6240\u6709\u8868\u7684\u8bed\u53e5\u4ecb\u7ecd\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u3010\u7f16\u8f91\u63a8\u8350\u3011<\/p>\n<p>Oracle with\u8bed\u53e5\u7684\u7528\u6cd5<\/p>\n<p>Oracle\u67e5\u8be2\u7528\u6237\u8868\u7a7a\u95f4\u7684\u5b9e\u73b0<\/p>\n<p>\u63d0\u9ad8Oracle\u6570\u636e\u5e93\u6548\u7387\u7684\u65b9\u6cd5<\/p>\n<p>Oracle\u7d22\u5f15\u7684\u4f18\u5316\u8bbe\u8ba1<\/p>\n<p>16\u79cdoracle\u67e5\u8be2\u65e5\u671f\u8bed\u53e5<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0b\u9762\u4e3a\u60a8\u4ecb\u7ecd\u7684\u8bed\u53e5\u7528\u4e8e\u5b9e\u73b0oracle\u67e5\u8be2\u7528\u6237\u6240\u6709\u8868\uff0c\u5982\u679c\u60a8\u5bf9oracle\u67e5\u8be2\u65b9\u9762\u611f\u5174\u8da3\u7684\u8bdd\uff0c\u4e0d\u59a8\u4e00\u770b\u3002 se [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7038],"tags":[],"class_list":["post-308117","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/308117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/comments?post=308117"}],"version-history":[{"count":0,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/308117\/revisions"}],"wp:attachment":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/media?parent=308117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/categories?post=308117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/tags?post=308117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}