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.

Examples[edit]

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;

Also see[edit]

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 #