{ DELETE FROM 表å?? [WHERE 節] | DELETE FROM 表å?? WHERE CURRENT OF }
一ã?¤ç›®ã?®æ›¸ã??æ–¹ã?¯ã€?検索ã?«ã‚ˆã‚‹å‰Šé™¤ã?¨å‘¼ã?°ã‚Œã€?表å??ã?¨WHERE 節ã?«ã‚ˆã‚Šçµžã‚Šè¾¼ã?¾ã‚Œã?Ÿè¡Œã?Œå‰Šé™¤ã?•れã?¾ã?™ã€‚
二ã?¤ç›®ã?®æ›¸ã??æ–¹ã?¯ã€?ä½?ç½®ã?«ã‚ˆã‚‹å‰Šé™¤ã?¨å‘¼ã?°ã‚Œã€?æ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?§ç?¾åœ¨é–‹ã?„ã?¦ã?„る行ã?Œå‰Šé™¤ã?•れã?¾ã?™ã€‚æ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?«ã?¤ã?„ã?¦ã?¯SELECT 文をå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
DELETE FROM SAMP.IN_TRAY stmt.executeUpdate("DELETE FROM SAMP.IN_TRAY WHERE CURRENT OF " + resultSet.getCursorName());
検索ã?«ã‚ˆã‚‹å‰Šé™¤ã?§ã?¯ã€?æ–‡ã?Œæ›´æ–°ã?™ã‚‹è¡¨ã‚„ã??ã?®ã‚³ãƒ³ã‚°ãƒãƒžãƒªãƒƒãƒˆ(ヒープや索引ã?®ã‚ˆã?†ã?ªè¨˜éŒ²ã?®å?˜ä½?)ã?«ã€?æ–‡ã?Œä¾?å˜ã?—ã?¾ã?™ã€‚準備ã?•れã?Ÿæ¤œç´¢ã?«ã‚ˆã‚‹å‰Šé™¤æ–‡ã?Œå¯¾è±¡ã?¨ã?™ã‚‹è¡¨ã?®CREATEã‚„DROP INDEXæ–‡ã?¯ã€?ã??ã?®æº–å‚™ã?•れã?Ÿæ¤œç´¢ã?«ã‚ˆã‚‹å‰Šé™¤æ–‡ã‚’無効ã?¨ã?—ã?¾ã?™ã€‚
ä½?ç½®ã?«ã‚ˆã‚‹å‰Šé™¤ã?§ã?¯ã€?æ–‡ã?Œã‚«ãƒ¼ã‚½ãƒ«ã‚„カーソルã?Œå?‚ç…§ã?™ã‚‹è¡¨ã?«ä¾?å˜ã?—ã?¾ã?™ã€‚ã?Ÿã?¨ã?ˆã?¾ã? カーソルã?Œé–‹ã?„ã?¦ã?ªã??ã?¦ã‚‚ã€?ä½?ç½®ã?«ã‚ˆã‚‹å‰Šé™¤ã?®æ–‡ã?¯ã‚³ãƒ³ãƒ‘イルå?¯èƒ½ã?§ã?™ã€‚ã??れã?§ã‚‚ã€?JDBCã?®closeメソッドã?«ã‚ˆã‚Šé–‹ã?„ã?Ÿã‚«ãƒ¼ã‚½ãƒ«ã?Œå?–り除ã?‹ã‚Œã‚‹ã?¨ã€?ä½?ç½®ã?«ã‚ˆã‚‹å‰Šé™¤ã?®æ–‡ã?¯ç„¡åйã?«ã?ªã‚Šã?¾ã?™ã€‚
準備ã?•れã?Ÿä½?ç½®ã?«ã‚ˆã‚‹å‰Šé™¤ã?®æ–‡ã?Œå¯¾è±¡ã?¨ã?™ã‚‹è¡¨ã?®CREATEã‚„DROP INDEXæ–‡ã?¯ã€?ã??ã?®æº–å‚™ã?•れã?Ÿä½?ç½®ã?«ã‚ˆã‚‹å‰Šé™¤ã?®æ–‡ã‚’無効ã?¨ã?—ã?¾ã?™ã€‚