Oracle DatabaseDifferent ways to update records


Syntax

  • UPDATE table-Name [[AS] correlation-Name] SET column-Name = Value [ , column-Name = Value} ]* [WHERE clause]
  • UPDATE table-Name SET column-Name = Value [ , column-Name = Value ]* WHERE CURRENT OF