Here we will learn about the UPDATE statement in Oracle. What is the use of it and syntax for the same.

Introduction

UPDATE statement is used to update one or more record in DB table.

Syntax for UPDATE statement

UPDATE <table_name> SET <column_name>  =<value> WHERE <condition>

TABLE_NAME

Name of the table of which record is going to be updated.

COLUMN_NAME

Name of column in table to update.

VALUES

Value with which above column will be updated

CONDITION

Used to filter out the records to update in table.

UPDATE Statement Example

Dummy Table

We will use employee dummy table for our example. DDL(Data definition language) query for employee would be

create table employee(name varchar2(10), surName varchar(20), Address varchar2(40), phone number)

Dummy Data

For example purpose we will populate dummu table with some dummy data. Below is the query for the same.

Query 1

Update all record in employee table with phone number as “111111” where phone >