Updating Multiple Rows
by Using SQL
You can use the SQL Command interface to perform updates as well as to control your transaction. The SQL Command interface allows you to enter an UPDATE statement. You can enter only one statement at a time. However, you can use one UPDATE statement to modify multiple records in a table based on a specific condition. When a condition is not specified, the entire table is updated.
Watch Sheila update rows in the EMPLOYEES table.
 |
