UPDATE 문

<update statement>

UPDATE <class specification> | <meta class specification> [ [ AS ] <identifier> ]
SET <update assignment comma list>
[ WHERE <search condition> ]
[ <using index clause> ]
| UPDATE OBJECT <oid variable>
SET <update assignment comma list>

<update assignment comma list>

<update assignment> [ { , <update assignment> }... ]

<update assignment>

(<attribute comma list>) = {(<query expression>)
| (<expression comma list>)}

<attribute comma list>

<attribute name> [{, <attribute name>}...]

예제

UPDATE resort
SET cost = $198.00
WHERE name = 'Tryall Golf, Tennis, and Beach Club';