UPDATE
Changes
column values in specified of a table.
SYNTAX
| table_name |
Name
of the table containing the rows you want to update. |
| column_name |
Name
of the column you want to update values in. |
| expression |
Expression
that returns a value to update the column with. |
| constant |
Constant
value to update the column with. |
| search_condition |
Conditions
a row must meet to be updated. |
| cursor_name |
Name
of the cursor to use for a positioned update. Cursors are only available
within ODBC programs. |
DESCRIPTION
The UPDATE
command updates existing rows in a table. You cannot update rows in the
system catalog tables. To execute the UPDATE command on a table you must
be the table owner, have DBA or SYSADM security privileges, or have UPDATE
privilege for the entire table or for the specific column you want to
insert data into.
When you
update a column, the new column values must satisfy the column constraints
and referential integrity. If the column has a default value defined,
you can use the DEFAULT keyword to set the value of the column to the
default value.
EXAMPLE
The following
example shows how to update the Employees table and change the salary
of all employees named "Jones".
UPDATE Employees SET Salary = 5000 WHERE Name = 'Jones'
|
The following
example shows how to give a salary raise of 10% to all employees named
"Trent".
UPDATE Employees SET Salary = Salary*1.10 WHERE Name = 'Trent'
|
RELATED COMMANDS
<
UNLOAD STATISTICS | Contents
| UPDATE STATISTICS >
|
