SQL Update
 

Oracle SQL 

SQL Introduction    SQL Introduction 

SQL Insert    SQL Insert

SQL Update    SQL Update

SQL Delete    SQL Delete

SQL Joins   SQL Joins 

SQL Subqueries    SQL Subqueries

SQL Views    SQL Views

Oracle PL/SQL

PL/SQL Introduction    PL/SQL Introduction

PL/SQL Cursors    PL/SQL Cursors

PL/SQL Triggers    PL/SQL Triggers

PL/SQL Interview Questions    PL/SQL Questions

SQL – Update

Update

Update Statement is used to change existing values in a table or a view's base table.

EXAMPLE :

update emp

          set sal = sal*2.25

          where deptno = 30

update emp

          set sal = sal*2.25

          where empno in ( select empno from emp_1 )