Update

From Oracle FAQ
Jump to: navigation, search

Update is a SQL DML command used to change data in a table. Note that it's important to specify a WHERE-clause, if not ALL rows in the table will be updated.

[edit] Examples

Give employees in department 10 an 10% raise:

UPDATE emp SET sal = sal*1.1 WHERE deptno = 10;

Give employee number 7844 a $100 commission:

UPDATE emp SET comm = 100 WHERE empno = 7844;

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #