SELECTæ–‡ã?«ã?¯FOR UPDATE節をæŒ?ã?Ÿã?›ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ 既定ã?§ã‚«ãƒ¼ã‚½ãƒ«ã?¯èªã?¿è¾¼ã?¿ã?—ã?‹ã?§ã??ã?¾ã?›ã‚“。FOR UPDATE節ã?«ã‚ˆã‚Šã€?コンパイルä¸ã?«SELECTæ–‡ã?Œæ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?®å¿…è¦?æ?¡ä»¶ã‚’満ã?Ÿã?™ã?‹ã‚’検証ã?—ã?¦ã€?カーソルを更新å?¯èƒ½ã?¨ã?—ã?¾ã?™ã€‚ æ›´æ–°å?¯èƒ½ã?§ã?‚ã‚‹ã?“ã?¨ã?®è©³ç´°ã?«ã?¤ã?„ã?¦ã?¯ã€?æ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?®å¿…è¦?æ?¡ä»¶ã‚’å?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
FOR { READ ONLY | FETCH ONLY | UPDATE [ OF å?˜ç´”列å?? [ , å?˜ç´”列å??]* ] }
å?˜ç´”列å?? ã?«ã‚ˆã‚Šã€?å•?ã?„å?ˆã‚?ã?›æ–‡ã?®FROM節ã?«ã?‚る表ã?«ã?¦ã€?å?¯è¦–ã?ªå??å‰?ã‚’å?‚ç…§ã?—ã?¾ã?™ã€‚
索引ã?®åˆ—ã?Œæ›´æ–°ã?•れã?¦ã?„ã?¦ã‚‚ã€?索引を使ã?£ã?Ÿæœ€é?©åŒ–ã?Œå?¯èƒ½ã?§ã?™ã€‚索引ã?Œã?©ã?®ã‚ˆã?†ã?«ã‚«ãƒ¼ã‚½ãƒ«ã?«å½±éŸ¿ã?™ã‚‹ã?‹ã?«ã?¤ã?„ã?¦ã?¯ã€?Derbyã?®ãƒ?ューニングをå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
SELECT RECEIVED, SOURCE, SUBJECT, NOTE_TEXT FROM SAMP.IN_TRAY FOR UPDATE