INSERTæ–‡ã?«ã‚ˆã‚Šä¸€ã?¤ä»¥ä¸Šã?®è¡Œã‚’作æˆ?ã?—ã?¦ã€?指定ã?—ã?Ÿå??å‰?ã?®è¡¨ã?«æ ¼ç´?ã?§ã??ã?¾ã?™ã€‚ INSERTæ–‡ã?§æŒ‡å®šã?•れã?Ÿå€¤ã?®æ•°ã?¯ã€?指定ã?•れã?Ÿåˆ—ã?‚ã‚‹ã?„ã?¯æš—示ã?•れã?Ÿåˆ—ã?®æ•°ã?¨å?Œã?˜ã?§ã?ªã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。
INSERT INTO 表å?? [ (å?˜ç´”列å?? [ , å?˜ç´”列å??]* ) ] å•?å?ˆã?›
å?˜ä¸€è¡Œã?‚ã‚‹ã?„ã?¯è¤‡æ•°è¡Œã?®ä¸€è¦§ã?«ã?¯ã€?DEFAULTã?¨ã?„ã?†ã‚ーワードをå?«ã‚?ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚列ã?«DEFAULTを指定ã?™ã‚‹ã?¨ã€?ã??ã?®åˆ—ã?«ã?¯æ—¢å®šå€¤ã?ŒæŒ¿å…¥ã?•れã?¾ã?™ã€‚列ã?«æ—¢å®šå€¤ã‚’挿入ã?™ã‚‹å ´å?ˆã€?列ã?®ä¸€è¦§ã?«ã?¦ã??ã?®åˆ—ã‚’çœ?ç•¥ã?—ã?¦ã€?表ã?®ã?»ã?‹ã?®åˆ—ã?«å€¤ã‚’挿入ã?™ã‚‹ã?“ã?¨ã‚‚ã?§ã??ã?¾ã?™ã€‚詳細ã?«ã?¤ã?„ã?¦ã?¯VALUESå¼?ã‚’å?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
å•?å?ˆã?›ã?®è©³ç´°ã?«ã?¤ã?„ã?¦ã?¯ã€?å•?å?ˆã?›ã‚’å?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
INSERT INTO COUNTRIES VALUES ('Taiwan', 'TW', 'Asia') -- DEPARTMENTã?¨ã?„ã?†è¡¨ã?«æ–°ã?—ã?„部署を挿入ã?—ã?¾ã?™ã€‚ -- ã?Ÿã? ã?—ã€?æ–°ã?—ã?„部署ã?«æ–°ã?—ã?„管ç?†è€…ã?¯å‰²ã‚Šå½“ã?¦ã?¾ã?›ã‚“。 INSERT INTO DEPARTMENT (DEPTNO, DEPTNAME, ADMRDEPT) VALUES ('E31', 'ARCHITECTURE', 'E01') -- 2ã?¤ã?®æ–°ã?—ã?„部署を一ã?¤ã?®æ–‡ã?§å‰?ã?¨å?Œã?˜ã‚ˆã?†ã?«DEPARTMENTã?¨ã?„ã?†è¡¨ã?«æŒ¿å…¥ã?—ã?¾ã?™ã€‚ -- ã?Ÿã? ã?—ã€?æ–°ã?—ã?„部署ã?«æ–°ã?—ã?„管ç?†è€…ã?¯å‰²ã‚Šå½“ã?¦ã?¾ã?›ã‚“。 INSERT INTO DEPARTMENT (DEPTNO, DEPTNAME, ADMRDEPT) VALUES ('B11', 'PURCHASING', 'B01'), ('E41', 'DATABASE ADMINISTRATION', 'E01') -- EMP_ACTã?¨å?Œã?˜åˆ—ã‚’æŒ?ã?¤ã€?MA_EMP_ACTã?¨ã?„ã?† -- 一時表を作りã?¾ã?™ã€‚ -- MA_EMP_ACTã?«EMP_ACTã?¨ã?„ã?†è¡¨ã?‹ã‚‰ã€? -- プãƒã‚¸ã‚§ã‚¯ãƒˆç•ªå?·(PROJNO)ã?Œ'MA'ã?¨ã?„ã?†æ–‡å—ã?§å§‹ã?¾ã‚‹è¡Œã‚’ãƒãƒ¼ãƒ‰ã?—ã?¾ã?™ã€‚ CREATE TABLE MA_EMP_ACT ( EMPNO CHAR(6) NOT NULL, PROJNO CHAR(6) NOT NULL, ACTNO SMALLINT NOT NULL, EMPTIME DEC(5,2), EMSTDATE DATE, EMENDATE DATE ); INSERT INTO MA_EMP_ACT SELECT * FROM EMP_ACT WHERE SUBSTR(PROJNO, 1, 2) = 'MA'; -- LOCATIONã?¨ã?„ã?†åˆ—ã?«DEFAULTã?®å€¤ã‚’挿入ã?—ã?¾ã?™ã€‚ INSERT INTO DEPARTMENT VALUES ('E31', 'ARCHITECTURE', '00390', 'E01', DEFAULT)
INSERT æ–‡ã?¯æŒ¿å…¥å…ˆã?®è¡¨ã‚„ã€?ã??ã?®è¡¨ã?®å…¨ã?¦ã?®ã‚³ãƒ³ã‚°ãƒãƒžãƒªãƒƒãƒˆ(ヒープや索引ã?ªã?©ã?®è¨˜éŒ²ã?®å?˜ä½?ã?§ã?™ã€‚)ã‚„ã€?æ–‡ä¸ã?®ã??ã?®ä»–ã?®è¡¨ã?«ä¾?å˜ã?—ã?¾ã?™ã€‚準備ã?•れã?ŸINSERTæ–‡ã?®å¯¾è±¡è¡¨ã?«ã?¦ã€?索引や制約を作æˆ?ã?—ã?Ÿã‚Šç ´æ£„ã?—ã?Ÿã‚Šã?™ã‚‹ã?¨ã€?ã??ã?®æº–å‚™ã?•れã?ŸINSERTæ–‡ã?¯ç„¡åйã?¨ã?ªã‚Šã?¾ã?™ã€‚