{"id":10391,"date":"2021-08-01T00:31:51","date_gmt":"2021-07-31T16:31:51","guid":{"rendered":"https:\/\/ailog.tw\/lifelog\/?p=10391"},"modified":"2021-08-10T20:48:32","modified_gmt":"2021-08-10T12:48:32","slug":"oracle-insert-into","status":"publish","type":"post","link":"https:\/\/ailog.tw\/lifelog\/2021\/08\/01\/oracle-insert-into\/","title":{"rendered":"Oracle Database INSERT INTO table SQL Command"},"content":{"rendered":"

Oracle Database \u57fa\u790e\u8a9e\u6cd5INSERT INTO table SQL Command\u4ecb\u7d39\uff0c\u5f88\u57fa\u790e\u7684\u8a9e\u6cd5\u4f46\u5c0d\u525b\u5165\u9580\u7684\u65b0\u624b\u9084\u662f\u6709\u53c3\u8003\u7684\u50f9\u503c\u3002<\/span><\/p>\n

\u4e00\u3001\u672c\u7bc4\u4f8b\u60c5\u5883\uff1a<\/span>
\n(1)\u3001\u4f7f\u7528Oracle SQL Developer\u8edf\u9ad4\u9032\u884c
\n(2)\u3001\u65b0\u589e\u55ae\u7b46\u7d00\u9304
\n(3)\u3001\u900f\u904e\u8ff4\u5708\u65b0\u589e\u591a\u7b46\u7d00\u9304<\/span><\/p>\n

\u4e8c\u3001\u65b0\u589e\u55ae\u7b46\u7d00\u9304
\n\u65b0\u589e\u55ae\u7b46\u7d00\u9304\u7bc4\u4f8b\u7684\u8a9e\u6cd5\uff1a<\/span>
\nINSERT INTO ailogtest<\/span>
\n(log_ID, log_NAME) <\/span>
\nVALUES (1, ‘oracle INSERT’);<\/span>
\n\"\"<\/span><\/p>\n

\u57f7\u884c\u7d50\u679c\uff1a
\n\"\"<\/span><\/p>\n

\u67e5\u770b\u5de6\u65b9TABLE\u5217\u8868\uff0c\u53ef\u770b\u898b\u525b\u525b\u65b0\u589e\u7684\u8cc7\u6599
\n\"\"<\/span><\/p>\n

\u4e09\u3001\u900f\u904e\u8ff4\u5708\u65b0\u589e\u591a\u7b46\u7d00\u9304
\n\u900f\u904e\u8ff4\u5708\u65b0\u589e\u591a\u7b46\u7d00\u9304\u7bc4\u4f8b\u7684\u8a9e\u6cd5\uff1a
\nbegin
\nfor i in 1 .. 10000000
\nloop
\ninsert into ailogtest values( i, ‘oracle INSERT’);
\nend loop;
\ncommit;
\nend;
\n\"\"
\n<\/span><\/p>\n

\u57f7\u884c\u7d50\u679c\uff1a
\n\"\"<\/span><\/p>\n

\u67e5\u770b\u65b0\u589e\u7684\u8cc7\u6599\u7b46\u6578\u662f\u5426\u6b63\u78ba\uff1a
\n\u7531\u65bc\u7b46\u6578\u592a\u591a\u4e86\uff0c\u6240\u4ee5\u900f\u904eSQL\u6307\u4ee4\u4f86\u7d71\u8a08\u4e00\u4e0b\u7e3d\u7b46\u6578\u3002
\n\u8a9e\u6cd5\uff1a
\nSELECT COUNT(*) FROM ailogtest;
\n\"\"<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Database \u57fa\u790e\u8a9e\u6cd5INSERT INTO table SQL Command\u4ecb\u7d39\uff0c\u5f88\u57fa\u790e … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008Oracle Database INSERT INTO table SQL Command\u3009<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":10400,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,387],"tags":[4568,4571,1105,4574,4570,4573,4569,4572],"class_list":["post-10391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itinfo","category-database","tag-insert-into","tag-loop","tag-oracle","tag-4574","tag-4570","tag-4573","tag-4569","tag-4572"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/comments?post=10391"}],"version-history":[{"count":5,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10391\/revisions"}],"predecessor-version":[{"id":10631,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10391\/revisions\/10631"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media\/10400"}],"wp:attachment":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media?parent=10391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/categories?post=10391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/tags?post=10391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}