FOR UPDATE 節

SELECTæ–‡ã?«ã?¯FOR UPDATE節をæŒ?ã?Ÿã?›ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ 既定ã?§ã‚«ãƒ¼ã‚½ãƒ«ã?¯èª­ã?¿è¾¼ã?¿ã?—ã?‹ã?§ã??ã?¾ã?›ã‚“。FOR UPDATE節ã?«ã‚ˆã‚Šã€?コンパイル中ã?«SELECTæ–‡ã?Œæ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?®å¿…è¦?æ?¡ä»¶ã‚’満ã?Ÿã?™ã?‹ã‚’検証ã?—ã?¦ã€?カーソルを更新å?¯èƒ½ã?¨ã?—ã?¾ã?™ã€‚ æ›´æ–°å?¯èƒ½ã?§ã?‚ã‚‹ã?“ã?¨ã?®è©³ç´°ã?«ã?¤ã?„ã?¦ã?¯ã€?æ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?®å¿…è¦?æ?¡ä»¶ã‚’å?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。

æ§‹æ–‡

FOR
{
    READ ONLY | FETCH ONLY |
    UPDATE [ OF å?˜ç´”列å?? [ , å?˜ç´”列å??]* ]
}

å?˜ç´”列å?? ã?«ã‚ˆã‚Šã€?å•?ã?„å?ˆã‚?ã?›æ–‡ã?®FROM節ã?«ã?‚る表ã?«ã?¦ã€?å?¯è¦–ã?ªå??å‰?ã‚’å?‚ç…§ã?—ã?¾ã?™ã€‚

注: æ›´æ–°å?¯èƒ½ã?ªJDBCã?®ResultSetã‚’å¾—ã‚‹ã?Ÿã‚?ã?«ã€?å¿…ã?šã?—ã‚‚FOR UPDATE節を使ã?†å¿…è¦?ã?¯ã?‚りã?¾ã?›ã‚“。 JDBCã?®ResultSetã?®å…ƒã?¨ã?ªã‚‹æ–‡ã?Œã€?æ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?®å¿…è¦?æ?¡ä»¶ã‚’満ã?Ÿã?—ã?¦ã?•ã?ˆã?„れã?°ã€?JDBC Statementã?‹ã‚‰ã€?並行処ç?†ãƒ¢ãƒ¼ãƒ‰ã?ŒResultSet.CONCUR_UPDATABLEã?®JDBC ResultSetを生æˆ?ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚

索引ã?®åˆ—ã?Œæ›´æ–°ã?•れã?¦ã?„ã?¦ã‚‚ã€?索引を使ã?£ã?Ÿæœ€é?©åŒ–ã?Œå?¯èƒ½ã?§ã?™ã€‚索引ã?Œã?©ã?®ã‚ˆã?†ã?«ã‚«ãƒ¼ã‚½ãƒ«ã?«å½±éŸ¿ã?™ã‚‹ã?‹ã?«ã?¤ã?„ã?¦ã?¯ã€?Derbyã?®ãƒ?ューニングをå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。

SELECT RECEIVED, SOURCE, SUBJECT, NOTE_TEXT FROM SAMP.IN_TRAY FOR UPDATE