UPDATE WHERE « Insert Delete Update « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Insert Delete Update
  3. UPDATE WHERE
1.Modify multiple rows with a single UPDATE statement
2.Without the WHERE clause, this UPDATE affects all rows in the table
3.Update with where condition
4.Change value case with update statement
5.Change department name to lower case