WHERE CURRENT OF節ã?¯UPDATEã‚„DELETEæ–‡ã?«ã?¦ä½¿ã?†ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ ã?“れã?«ã‚ˆã‚Šæ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?®ä½?ç½®ã?«ã‚ˆã‚‹æ›´æ–°ã‚„削除ã?Œè¡Œã?ˆã?¾ã?™ã€‚ æ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã?®è©³ç´°ã?«ã?¤ã?„ã?¦ã?¯ã€?SELECT 文をå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
WHERE CURRENT OF カーソルå??
Statement s = conn.createStatement(); s.setCursorName("AirlinesResults"); ResultSet rs = conn.executeQuery( "SELECT Airline, basic_rate " + "FROM Airlines FOR UPDATE OF basic_rate"); Statement s2 = conn.createStatement(); s2.executeUpdate("UPDATE Airlines SET basic_rate = basic_rate " + "+ .25 WHERE CURRENT OF AirlinesResults");