The WHERE CURRENT OF clause is a clause in some UPDATE and DELETE
statements. It allows you to perform positioned updates and deletes on updatable
cursors. For more information about updatable cursors, see .
SyntaxWHERE CURRENT OF cursor-NameStatement 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");