Skip to Main Content

Update a Column in Table

User_H95GNJan 15 2018 — edited Jan 16 2018

Oracle RAC: 11.2.0.3.0

Nodes: 2

OS: Red Hat Linux 6.8

SCHEMA NAME: TEST

Table Name: ACCOUNT

COLUMN NAME: SOURCE

Question:  I would like to change all the values in a column to 'external' in a table called ACCOUNT, in schema called TEST,  using the command:

Update TEST.ACCOUNT

SET SOURCE='external';

would this command change it ?

Currently it shows the following values

Column.png

Thanks for your help.

Comments
Post Details
Added on Jan 15 2018
2 comments
79 views