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

Thanks for your help.

Added on Jan 15 2018

2 comments

79 views