Modifying Data

During everyday operations in a company, data constantly requires changes. Sheila can make changes to existing records in a table by performing an UPDATE operation. While performing an UPDATE, Sheila needs to specify the column(s) and row that she is modifying as well as the new value(s).

The Object Browser interface of Application Express provides an easy-to-use interface for changing data. However, for updates to multiple records or to update special data types such as CLOBs, Sheila must use the SQL command interface.