{"id":17,"date":"2013-12-27T16:53:02","date_gmt":"2013-12-27T08:53:02","guid":{"rendered":"http:\/\/www.royalwzy.com\/?page_id=17"},"modified":"2015-09-09T21:52:13","modified_gmt":"2015-09-09T13:52:13","slug":"oracle-basics","status":"publish","type":"page","link":"http:\/\/www.royalwzy.com\/?page_id=17","title":{"rendered":"Oracle Basics"},"content":{"rendered":"

ORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752801–DBNEWID<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752802–DBVERIFY<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752803–LogMiner<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752804–TRCSESS<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752805–TKPROF<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752806–ORADEBUG<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752807–BBED<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752808–OERR<\/a>
\nORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752809–COPY<\/a><\/p>\n

\u811a\u672c\u5de5\u517701–\u628a\u67d0\u4e00\u4e2a\u5b57\u7b26\u4e32\u6309\u7167\u6307\u5b9a\u7684\u5206\u9694\u7b26\u5206\u9694,\u5e76\u4ee5Table\u5f62\u5f0f\u8fd4\u56de<\/a><\/p>\n

VMWare\u4e0b\u642d\u5efaLinux\/Oralce\u73af\u5883<\/a>
\nOracle \u4e2dsys\u548csystem\u7528\u6237\u533a\u522b<\/a>
\nOracle RETURNING INTO \u7528\u6cd5\u793a\u4f8b<\/a>
\nOracle\u4e2dSID\u7684\u4f5c\u7528<\/a>
\nOracle 10g \u67e5\u8be2\u95ea\u56de\u529f\u80fd\u5e94\u7528<\/a>
\nOracle Flashback \u95ea\u56de\u67e5\u8be2\u529f\u80fd9i\u548c10g\u7684\u533a\u522b<\/a>
\nOracle\u5305\u3001\u51fd\u6570\u3001\u8fc7\u7a0b\u7684\u52a0\u5bc6\u548c\u89e3\u5bc6<\/a>
\nOracle UTL_FILE<\/a>
\nSqlServer\u6570\u636e\u5e93\u8bbf\u95eeOracle\u6570\u636e\u5e93<\/a>
\nDELETE, TRUNCATE, DROP \u7684\u533a\u522b<\/a>
\nCREATE SEQUENCE command<\/a>
\nlag()\u548clead()<\/a>
\nDBMS_ERRLOG.CREATE_ERROR_LOG\u8bb0\u5f55\u9519\u8bef\u65e5\u5fd7<\/a>
\ndbms_stats.import_table_stats\u4e0d\u53ef\u4ee5\u628a\u7edf\u8ba1\u4fe1\u606f\u5bfc\u7ed9\u522b\u7684\u8868<\/a>
\nLimit SQL*Plus operation<\/a>
\n\u5728\u7ed9\u5b9a\u65f6\u95f4\u95f4\u9694\uff0c\u6c42\u95f4\u9694\u5185\u51fa\u73b0\u7684\u8bb0\u5f55\u6570<\/a>
\n\u521b\u5efa\u5e26\u53c2\u6570\u7684\u89c6\u56fe<\/a>
\nOracle Varray\u53d8\u91cf<\/a>
\nSecureFile LOBs and BasicFile LOBs<\/a>
\n\u4f7f\u7528SQL\u5b9e\u73b0\u5bf9\u90ae\u653f\u7f16\u7801\u5206\u7c7b\u89c4\u5219<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

ORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752801–DBNEWID ORACLE\u4e2d\u5de5\u5177\u7684\u4f7f\u752802–DBVER […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":21,"menu_order":10,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-17","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17"}],"version-history":[{"count":2,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/17\/revisions"}],"predecessor-version":[{"id":901,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/17\/revisions\/901"}],"up":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/21"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}