WHERE CURRENT OF 節

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");