The interactions in this eCourse require Javascript to be enabled.
Updating Multiple Rows by Using SQL
previous|next
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.