{"id":258,"date":"2025-10-17T16:50:33","date_gmt":"2025-10-17T08:50:33","guid":{"rendered":"https:\/\/www.youvii.site\/?p=258"},"modified":"2025-10-17T16:52:48","modified_gmt":"2025-10-17T08:52:48","slug":"oracledbcaozuo","status":"publish","type":"post","link":"https:\/\/www.youvii.site\/index.php\/archives\/oracledbcaozuo","title":{"rendered":"OracleDB\u64cd\u4f5c"},"content":{"rendered":"<h1>Oracle DB\u64cd\u4f5c<\/h1>\n<blockquote>\n<p>\u672c\u9875\u539f\u521b\u4f5c\u8005\uff1a<a href=\"https:\/\/blog.csdn.net\/qq_42589612\/article\/details\/80943957\">https:\/\/blog.csdn.net\/qq_42589612\/article\/details\/80943957<\/a><\/p>\n<p><font style=\"color:#333333;background-color:#ffffff;\">Oracle\u5b98\u65b9\uff1a<a href=\"http:\/\/www.oracle.com\">http:\/\/www.oracle.com<\/a><\/font><\/p>\n<\/blockquote>\n<p>Oracle \u7684\u5b89\u88c5<\/p>\n<p>\u4ece\u5b98\u7f51<font style=\"color:#333333;background-color:#ffffff;\"><a href=\"http:\/\/www.oracle.com\">http:\/\/www.oracle.com<\/a><\/font>\u4e0b\u8f7d\u7a0b\u5e8f\u5b89\u88c5\u5305\uff0c\u89e3\u538b\u540e\u53cc\u51fbsetup.exe\uff0c\u63a5\u4e0b\u6765\u662f\u6b63\u5e38\u7684\u5b89\u88c5\u6b65\u9aa4<\/p>\n<p>\u6570\u636e\u5e93\u521b\u5efa\u5b8c\u6bd5\u540e\uff0c\u9700\u8981\u8bbe\u7f6e\u6570\u636e\u5e93\u7684\u9ed8\u8ba4\u7528\u6237\uff0cOracle\u4e3a\u7ba1\u7406\u5458\u9884\u7f6e\u4e86\u4e24\u4e2a\u7528\u6237\u5206\u522b\u662fSYS\u548cSYSTEM\uff0c\u540c\u65f6\u63d0\u4f9b\u4e86\u4e00\u4e2a\u666e\u901a\u7528\u6237scott\uff0c\u53e3\u4ee4\u7ba1\u7406\u4e2d\uff0c\u53ef\u4ee5\u5bf9\u6570\u636e\u5e93\u7528\u6237\u8bbe\u7f6e\u5bc6\u7801\uff0c\u8bbe\u7f6e\u662f\u5426\u9501\u5b9a\u3002 Oracle\u5ba2\u6237\u7aef\u4f7f\u7528\u7528\u6237\u540d\u548c\u5bc6\u7801\u767b\u5f55Oracle\u7cfb\u7edf\u540e\u624d\u80fd\u5bf9\u6570\u636e\u5e93\u64cd\u4f5c\u3002\u9ed8\u8ba4\u7684\u7528\u6237\u4e2d\uff0cSYS\u548cSYSTEM\u7528\u6237\u662f\u6ca1\u6709\u9501\u5b9a\u7684\uff0c\u5b89\u88c5\u6210\u529f\u540e\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\uff0cSCOTT\u7528\u6237\u9ed8\u8ba4\u4e3a\u9501\u5b9a\u72b6\u6001\uff0c\u56e0\u6b64\u4e0d\u80fd\u76f4\u63a5\u4f7f\u7528\uff0c\u9700\u8981\u628aSCOTT\u7528\u6237\u8bbe\u5b9a\u4e3a\u975e\u9501\u5b9a\u72b6\u6001\u624d\u80fd\u6b63\u5e38\u4f7f\u7528\u3002<\/p>\n<p>Oracle\u6570\u636e\u5e93\u4e2d\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6240\u6709\u7cfb\u7edf\u7684\u6570\u636e\uff0cSQL\u5173\u952e\u5b57\u7b49\u90fd\u662f\u5927\u5199\u7684\uff0c\u5728\u64cd\u4f5c\u8fc7\u7a0b\u4e2d\uff0cOracle\u4f1a\u81ea\u52a8\u628a\u8fd9\u4e9b\u5185\u5bb9\u8f6c\u6362\u4e3a\u5927\u5199\uff0c\u56e0\u6b64\u7528\u6237\u64cd\u4f5c\u65f6\u4e0d\u9700\u8003\u8651\u5927\u5c0f\u5199\u95ee\u9898\uff0c\u4e00\u822c\u60c5\u51b5\u4e0b\uff0c\u4e3a\u4e86\u826f\u597d\u7684\u7a0b\u5e8f\u98ce\u683c\uff0c\u7a0b\u5e8f\u4e2d\u5efa\u8bae\u5173\u952e\u5b57\u7528\u5927\u5199\uff0c\u975e\u5173\u952e\u5b57\u53ef\u4ee5\u4f7f\u7528\u5c0f\u5199\u3002<\/p>\n<p>\u8be5\u5de5\u5177\u662fOracle\u7cfb\u7edf\u9ed8\u8ba4\u5b89\u88c5\u4e0b\uff0c\u81ea\u5e26\u7684\u4e00\u4e2a\u5ba2\u6237\u7aef\u5de5\u5177\u3002\u5728Windows\u547d\u4ee4\u884c\u4e2d\u8f93\u5165\u201csqlplusw\u201d\u547d\u4ee4\uff0c\u5c31\u80fd\u591f\u542f\u52a8\u8be5\u5de5\u5177\u4e86\uff0c\u8f93\u5165\uff1asqlplus\u8f93\u5165\u5bc6\u7801\u540e\u5c31\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u4e86<\/p>\n<p>Oracle\u6570\u636e\u5e93\u7684\u7aef\u53e3\u53f7\u662f1521\u3002<\/p>\n<p>Oracle\u6570\u636e\u5e93-scott\u7528\u6237<\/p>\n<p>sqlplus\u65e0\u56fe\u5f62\u754c\u9762\uff0c\u5982\u679c\u60f3\u8981\u6253\u5f00\u6587\u4ef6<\/p>\n<p>\u4f7f\u7528ed\u6587\u4ef6\u8def\u5f84 \u9ed8\u8ba4\u6253\u5f00\u7684\u662f\u4ee5.sql\u7ed3\u5c3e\u7684\u6587\u4ef6<\/p>\n<p>\u5982\u679c\u60f3\u8981\u6267\u884c\u67d0\u4e2a\u6587\u4ef6<\/p>\n<p>\u4f7f\u7528@\u6587\u4ef6\u8def\u5f84\uff0c\u5982\u679c\u6253\u5f00\u7684\u662f.sql\u6587\u4ef6\u540e\u7f00\u53ef\u4ee5\u4e0d\u5199<\/p>\n<p>scott\u662f\u9ed8\u8ba4\u7528\u6237\uff0c\u9700\u8981\u5bfc\u5165\u624d\u80fd\u4f7f\u7528<\/p>\n<p>\u5bfc\u5165scott\u7684\u7528\u6237\uff08\u9ed8\u8ba4scott\u7528\u6237\u4e3a\u9501\u5b9a\u72b6\u6001\uff09<\/p>\n<p>@D:oracleapporacleproduct11.2.0serverrdbmsadminscott<\/p>\n<p>\u89e3\u9501scott\u7528\u6237 alter user scott account unlock;<\/p>\n<p>\u8bbe\u7f6escott\u5bc6\u7801\u751f\u6548 alter user scott identified by tiger;<\/p>\n<p>\u5207\u6362\u7528\u6237<\/p>\n<p>\u767b\u9646SYS\u7528\u6237\u7684\u65f6\u5019\u9700\u8981\u4ee5sysdba\u7684\u8eab\u4efd\u767b\u5f55 sys\/root as sysdba;<\/p>\n<p>\u5207\u6362\u7528\u6237 conn \u7528\u6237\u540d\/\u7528\u6237\u5bc6\u7801<\/p>\n<p>\u6ce8\u610f\u5207\u6362\u5230sys\u7528\u6237 connsys\/root as sysdba;<\/p>\n<p>\u663e\u793a\u5f53\u524d\u7528\u6237 show user;<\/p>\n<p>\u67e5\u770b\u7528\u6237\u4e0b\u6240\u6709\u7684\u8868 select * from tab;<\/p>\n<p>\u663e\u793a\u683c\u5f0f\u5316<\/p>\n<p>\u8bbe\u7f6e\u6bcf\u9875\u663e\u793a\u6761\u6570 set pagesize 30;<\/p>\n<p>\u8bbe\u7f6e\u6bcf\u9875\u663e\u793a\u5bbd\u5ea6 set linesize 300;<\/p>\n<p>\u8bbe\u7f6e\u67d0\u4e2a\u5b57\u6bb5\u663e\u793a\u5bbd\u5ea6  <\/p>\n<p>\u5b57\u7b26\u4e32<\/p>\n<p>col \u5b57\u6bb5\u540d for a10;<\/p>\n<p>\u6570\u503c<\/p>\n<p>col \u5b57\u6bb5\u540d for 9999;\uff08\u51e0\u4f4d\u6570\u5c31\u586b\u51e0\u4e2a9\uff09<\/p>\n<p>\u6570\u636e\u5e93\u7528\u6237\u7ba1\u7406<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f2028acfd95.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920455772-80f7c9c1-a8b7-4522-9ba9-c326d4d53ce4.png\" \/>  <\/p>\n<p>sys\u7ba1\u7406\u5458\u9ed8\u8ba4\u5bc6\u7801\u4e3a change_on_install<\/p>\n<p>\u5982\u679c\u5728\u4e00\u4e2a\u7528\u6237\u4e0b\u8bbf\u95ee\u5176\u4ed6\u7528\u6237\u7684\u8868\uff0c\u9700\u8981\u52a0\u4e0a\u6a21\u5f0f\u540d\u79f0<\/p>\n<p>select * from scott.emp;  <\/p>\n<p>Oracle\u6570\u636e\u5e93 \u6570\u636e\u5b9a\u4e49\u8bed\u8a00 <\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f2028d8d024.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920455883-ddccd78b-3c77-4bf4-aea2-3f2dacfd929e.png\" \/><\/p>\n<p>INSERT \u589e\u52a0\u8868<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202908e2c7.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920455938-af60ec3c-9c1e-4c7c-a9ed-353b622895cf.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f20293407fa.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920455818-18663a56-6702-4a06-8d66-012d1577c8f9.png\" \/><\/p>\n<p>UPDATE \u66f4\u65b0\u8868<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f20295a7130.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920455825-58aabe53-c270-4e90-834c-3380609ad97c.png\" \/><\/p>\n<p>DELETE \u5220\u9664\u8868<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f2029829879.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457552-813bb69d-7945-4842-8971-0359e6d0f4d9.png\" \/><\/p>\n<p>SELECT \u67e5\u8be2\u8868<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f2029a73fe8.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457569-b3724c00-82cd-4efe-8c5d-92df40b73af8.png\" \/><\/p>\n<p>Oracle \u6570\u636e\u5e93\u64cd\u4f5c\u7b26<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f2029d0fbba.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457551-cecf042c-cb44-4101-b9a9-0ba22dcfc987.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f2029fc16d3.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457557-2d5d677b-8188-46ae-bdfd-8c62a0196daa.png\" \/><\/p>\n<p>\u6570\u636e\u5e93\u51fd\u6570<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202a21ecab.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457532-75dc7797-d04c-4aaf-b18e-a128e4378382.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202a44e3ac.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457837-885a2fa5-2569-485a-8b66-4f70394e74db.png\" \/><\/p>\n<p>Oracle \u6570\u636e\u5e93\u8f6c\u6362\u51fd\u6570<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202a727d0b.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457818-09d7a9a7-6eab-4074-bed9-b0921af5685c.png\" \/><\/p>\n<p>Oracle \u6570\u636e\u5e93\u4e2d\u7684\u591a\u8868\u67e5\u8be2<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202a9cb704.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920457787-5fe1a4c2-e887-41fb-8641-cff88d6526ef.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202abcc396.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458057-230dadc0-77b9-40ba-bfbd-080f97132abc.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202adebb35.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458371-cff9764f-73e3-4c2a-8e2c-7f0a8da89b5f.png\" \/><\/p>\n<p>Oracle\u6570\u636e\u5e93\u4e2d \u6570\u636e\u96c6\u5408\u64cd\u4f5c<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202b04b534.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458259-56f5df3b-cc9c-427b-a031-8656724ed598.png\" \/><\/p>\n<p>\u8ba1\u6570\u51fd\u6570<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202b2c9a19.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458251-95d78b64-05c4-4160-98a4-1333e33230d6.png\" \/><\/p>\n<p>\u5206\u7ec4\u67e5\u8be2<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202b4b7463.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458327-d98433c0-806e-4973-9ae8-b5f4bcbb3ac1.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202b6eede8.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458552-fdb2694f-3b0d-4977-b60a-11a7abb0c049.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202b94a6be.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458784-0eff8c41-0bc5-459b-a4ce-bdb11ba95672.png\" \/><\/p>\n<p>\u5b50\u67e5\u8be2<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202bb653b8.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458745-6793bffb-ecd6-40c8-8788-3335595b4b87.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202bd51246.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458754-40ca4212-7aa3-4bfa-8bf4-2e546cfd0642.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202bfac663.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458747-bd37ba9b-b2a4-4a50-8dac-2c633e4d5f9f.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202c20ed63.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920458980-ad5b0b70-cb69-409d-ad31-0746776e78c9.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202c3ef73d.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920459622-674f703d-c2a2-438f-b75a-175019ea432a.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202c5d47c4.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920459586-a2a271d4-1928-489f-bda1-36706bb7edef.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202c801a90.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920459609-36dfbe4e-ecb2-4855-8e43-54cecde8ce44.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202ca0fda6.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920459585-f80017a0-eea9-41da-bac3-37cbdad47a71.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202cc42c1d.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920459776-c2e8eeed-78ca-482a-b83e-c707c551d532.png\" \/><\/p>\n<p>\u7ea6\u675f\u7684\u4fee\u6539<\/p>\n<p>ALTER TABLE \u8868\u540d<\/p>\n<p>ADD CONSTRAINT CHAR(6)<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202ce2f096.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920460542-987ab2c4-b529-4b2e-931e-f826f96514ce.png\" \/><\/p>\n<p>\u7ed3\u6784\u7684\u4fee\u6539<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202d0132ca.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920460582-91a13699-55e2-45fa-a819-6d805cab1cc1.png\" \/><\/p>\n<p>\u4e8b\u52a1<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202d261e24.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920460558-dea77c96-b1ec-472b-86a3-67b4422d8c99.png\" \/><\/p>\n<p>\u5e8f\u5217<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202d4728e9.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920460549-1113ab67-8486-4587-942b-43adf6362e4f.png\" \/><\/p>\n<p>\u6570\u636e\u7f16\u53f7<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202d6b3e31.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920460727-b1e6e2a4-c55f-4228-9bfe-a05b24c03fc5.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202d8b32cb.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920461521-7e93ea72-b223-442b-9a1a-697443115afe.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202daa9227.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920461503-184d7d19-bda7-4c8f-a61b-3b8e6ea2237b.png\" \/><\/p>\n<p>\u540c\u4e49\u8bcd<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202dc9969a.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920461554-ae9427a9-fdce-4897-ab68-f9c3e936ca3f.png\" \/><\/p>\n<p>\u89c6\u56fe\uff08\u5c06\u590d\u6742\u7684\u67e5\u8be2\u8fdb\u884c\u5c01\u88c5\u80fd\u591f\u76f4\u63a5\u4f7f\u7528\uff09<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202de7e87e.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920461530-7845dac6-ed75-46d7-9e12-30f10d58a1d1.png\" \/><\/p>\n<p>\u66ff\u6362\u89c6\u56fe<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202e1a7cc0.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920461743-c6c1c6e0-ccd6-4cb7-bfc8-f97901127b9e.png\" \/><\/p>\n<p>\u6570\u636e\u7684\u5bfc\u5165\u5bfc\u51fa<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202e3c0da1.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920462461-1fdb162d-b0cc-42a0-86f8-39722865caf2.png\" \/><\/p>\n<p>\u6848\u4f8b\uff1a<\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202e5d813f.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920462436-c62ea7a6-f523-416b-bb33-9f24ddf29e72.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202e7aaa51.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920462368-edc51b35-311f-48b0-8fc0-8b590f6c8773.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202e99349c.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920462374-ed7eb0c8-e3a1-4d30-9fce-74583da4553a.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202eb53f3f.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920462557-38638574-8a0d-4ea8-9b46-9536385efd20.png\" \/><\/p>\n<p><img loading="lazy" decoding="async" decoding=\"async\"  src=\"https:\/\/www.youvii.site\/wp-content\/themes\/lolimeow-lolimeowV13.13\/assets\/images\/loading.gif\" data-src=\"https:\/\/cdn.picui.cn\/vip\/2025\/10\/17\/68f202ed58ac8.png\" class=\"lazy\" loading=\"lazy\" alt=\"1741920463324-b40e710c-13d4-4cd4-8307-221c27828fe9.png\" \/><\/p>\n<blockquote>\n<p>\u66f4\u65b0: 2025-04-11 20:56:42<br \/>\n\u539f\u6587: <a href=\"http:\/\/www.yuque.com\/yuhui.net\/network\/rwdmw8pcqgza2olf\">http:\/\/www.yuque.com\/yuhui.net\/network\/rwdmw8pcqgza2olf<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Oracle DB\u64cd\u4f5c \u672c\u9875\u539f\u521b\u4f5c\u8005\uff1ahttps:\/\/blog.csdn.net\/qq_42589612\/article\/details\/80943957 Oracle\u5b98\u65b9\uff1ahttp:\/\/www.oracle.com Oracle \u7684\u5b89\u88c5 \u4ece\u5b98\u7f51http:\/\/www.oracle.com\u4e0b\u8f7d\u7a0b\u5e8f\u5b89\u88c5\u5305\uff0c\u89e3\u538b\u540e\u53cc\u51fbsetup.exe\uff0c\u63a5\u4e0b\u6765\u662f\u6b63\u5e38\u7684\u5b89\u88c5\u6b65\u9aa4 \u6570\u636e\u5e93\u521b\u5efa\u5b8c\u6bd5\u540e\uff0c\u9700\u8981\u8bbe\u7f6e\u6570\u636e\u5e93\u7684\u9ed8\u8ba4\u7528\u6237 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[59,60],"class_list":["post-258","post","type-post","status-publish","format-standard","hentry","category-database","tag-oracledb","tag-shujuku"],"_links":{"self":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/posts\/258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/comments?post=258"}],"version-history":[{"count":0,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/posts\/258\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/media?parent=258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/categories?post=258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/tags?post=258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}