{ UPDATE 表å?? SET 列å?? = 値 [ , 列å?? = 値} ]* [WHERE節] | UPDATE 表å?? SET 列å?? = 値 [ , 列å?? = 値 ]* WHERE CURRENT OF }
値�定義�以下�通り��。
å¼? | DEFAULT
一ã?¤ç›®ã?®æ›¸ã??æ–¹ã?¯æ¤œç´¢ã?«ã‚ˆã‚‹æ›´æ–°ã?¨ã?„ã?„ã€?WHERE節ã?ŒçœŸã?«è©•価ã?•れる全行ã?®ä¸€ã?¤ä»¥ä¸Šã?®åˆ—ã‚’æ›´æ–°ã?—ã?¾ã?™ã€‚
二ã?¤ç›®ã?®æ›¸ã??æ–¹ã?¯ä½?ç½®ã?«ã‚ˆã‚‹æ›´æ–°ã?¨ã?„ã?„ã€?æ›´æ–°å?¯èƒ½ã?ªé–‹ã?„ã?Ÿã‚«ãƒ¼ã‚½ãƒ«ã?®ç?¾åœ¨è¡Œã?®ä¸€ã?¤ä»¥ä¸Šã?®åˆ—ã‚’æ›´æ–°ã?—ã?¾ã?™ã€‚カーソルを作æˆ?ã?™ã‚‹SELECTæ–‡ã?®FOR UPDATE 節ã?«ã?¦åˆ—ã?Œæ˜Žç¤ºã?•れã?Ÿå ´å?ˆã€?ã??ã?®åˆ—ã? ã?‘ã?Œæ›´æ–°å?¯èƒ½ã?§ã?™ã€‚ã‚‚ã?—列ã?Œæ˜Žç¤ºã?•れã?¦ã?„ã?ªã?„ã?‹SELECTæ–‡ã?«FOR UPDATE節ã?Œç„¡ã?‹ã?£ã?Ÿå ´å?ˆã?¯ã€?å…¨ã?¦ã?®åˆ—ã‚’æ›´æ–°ã?§ã??ã?¾ã?™ã€‚
更新後ã?®å€¤ã?«DEFAULTを指定ã?™ã‚‹ã?¨ã€?表ã?«ã?¦å®šç¾©ã?•れã?Ÿæ—¢å®šå€¤ã?«åˆ—ã?®å€¤ã?Œè¨å®šã?•れã?¾ã?™ã€‚
-- 'E21'ã?®éƒ¨ç½²(WORKDEPT)ã?«ã?¦ç®¡ç?†è€…以外ã?Œä¸€æ™‚çš„ã?«å†?é…?属ã?•れã?¦ã?„る。 -- ã?“ã?®ã?“ã?¨ã‚’ã€?EMPLOYEEã?¨ã?„ã?†è¡¨ã?®å½¼ã‚‰ã?®ä»•事(JOB)ã‚’NULLã?«ã€? -- 彼らã?¸ã?®æ”¯æ‰•ã?„(SALARY, BONUS, COMM)ã‚’0ã?«ã?—ã?¦ã?‚らã‚?ã?™ã€‚ UPDATE EMPLOYEE SET JOB=NULL, SALARY=0, BONUS=0, COMM=0 WHERE WORKDEPT = 'E21' AND JOB <> 'MANAGER' -- 特定ã?®è‚©æ›¸ã??ã‚’æŒ?ã?Ÿã?ªã?„社員を管ç?†è€…ã?«æ˜‡æ ¼ã?™ã‚‹ã€‚ UPDATE EMPLOYEE SET JOB = 'MANAGER' WHERE JOB IS NULL; // å…¨ã?¦ã?®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã?®äººå“¡é…?ç½®(PRSTAFF)ã‚’1.5増やã?™ã€‚ stmt.executeUpdate("UPDATE PROJECT SET PRSTAFF = " "PRSTAFF + 1.5" + "WHERE CURRENT OF" + ResultSet.getCursorName()); -- EMPLOYEEã?¨ã?„ã?†è¡¨ã?«ã?¦ç¤¾å“¡ç•ªå?·(EMPNO)ã?Œ'000290'ã?®ç¤¾å“¡ã?®ä»•事(JOB)ã‚’ã€? -- 既定値ã?§ã?‚ã‚‹NULLã?«æ›´æ–°ã?™ã‚‹ã€‚ UPDATE EMPLOYEE SET JOB = DEFAULT WHERE EMPNO = '000290'
検索ã?«ã‚ˆã‚‹æ›´æ–°ã?®æ–‡ã?¯ã€?æ›´æ–°ã?—よã?†ã?¨ã?—ã?¦ã?„る表やã€?ã??ã?®ã‚³ãƒ³ã‚°ãƒãƒžãƒªãƒƒãƒˆ(ヒープや索引ã?ªã?©ã?®è¨˜éŒ²å?˜ä½?)ã€?ã??ã?®åˆ¶ç´„ã€?WHERE節やSETå¼?ã?«æ›¸ã?‹ã‚Œã?Ÿè¡¨ã?«ä¾?å˜ã?—ã?¾ã?™ã€‚検索ã?«ã‚ˆã‚‹æ›´æ–°ã?®æº–å‚™ã?•れã?Ÿæ–‡ã?®å¯¾è±¡è¡¨ã?«CREATE INDEXã‚„DROP INDEXæ–‡ã€?ALTER TABLEæ–‡ã?Œå®Ÿè¡Œã?•れるã?¨ã€?ã??ã?®æ–‡ã?¯ç„¡åйã?¨ã?ªã‚Šã?¾ã?™ã€‚
ä½?ç½®ã?«ã‚ˆã‚‹æ›´æ–°ã?®æ–‡ã?¯ã‚«ãƒ¼ã‚½ãƒ«ã‚„カーソルã?Œå?‚ç…§ã?™ã‚‹å…¨ã?¦ã?®è¡¨ã?«ä¾?å˜ã?—ã?¾ã?™ã€‚カーソルã?Œã?¾ã? é–‹ã?„ã?¦ã?„ã?ªã??ã?¨ã‚‚ã€?ä½?ç½®ã?«ã‚ˆã‚‹æ›´æ–°ã?®æ–‡ã‚’コンパイルã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ã?—ã?‹ã?—ã?ªã?Œã‚‰JDBCã?®closeメソッドã?«ã‚ˆã‚Šé–‹ã?„ã?Ÿã‚«ãƒ¼ã‚½ãƒ«ã‚’ã?ªã??ã?™ã?¨ã€?ä½?ç½®ã?«ã‚ˆã‚‹æ›´æ–°ã?®æ–‡ã?¯ç„¡åйã?¨ã?ªã‚Šã?¾ã?™ã€‚
ä½?ç½®ã?«ã‚ˆã‚‹æ›´æ–°ã?®æº–å‚™ã?•れã?Ÿæ–‡ã?®å¯¾è±¡è¡¨ã?«ã€?CREATE INDEXã‚„DROP INDEXæ–‡ã€?ALTER TABLEæ–‡ã?Œå®Ÿè¡Œã?•れるã?¨ã€?ã??ã?®æ–‡ã?¯ç„¡åйã?¨ã?ªã‚Šã?¾ã?™ã€‚
別å??ã‚’ç ´æ£„ã?™ã‚‹ã?¨ã€?ã??ã?®åˆ¥å??を使ã?£ã?¦ã?„ã‚‹æ›´æ–°ã?®æº–å‚™ã?•れã?Ÿæ–‡ã?¯ç„¡åйã?«ã?ªã‚Šã?¾ã?™ã€‚
æ›´æ–°ã?®å¯¾è±¡è¡¨ã?«ã?¦ãƒˆãƒªã‚¬ã?®ç ´æ£„や作æˆ?ã?Œè¡Œã‚?れるã?¨ã€?æ›´æ–°ã?®æ–‡ã?¯ç„¡åйã?«ã?ªã‚Šã?¾ã?™ã€‚