UPDATE Set Clause « Insert Delete Update « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Insert Delete Update
  3. UPDATE Set Clause
1.You can update a column and set it back to the default using the DEFAULT keyword in an UPDATE statement
2.Use arithmetic operators and functions in the SET clause to modify data
3.An example of using a function in the SET clause
4.Change multiple rows and multiple columns in the same UPDATE statement
5.Use TO_DATE('December 31, 2002, 11:30 P.M.','Month dd, YYYY, HH:MI P.M.') in set statement
6.Update data from existing column
7.Update four columns
8.Update number type column
9.Update one row