Adding column to existing tables

Question

I am working on an Oracle database. I have to add a new column to 2 existing tables.

The tables are, T_VERIFY_NAME & T_VERIFY_ADDRESS

Now the new field/column to add is, UC_VALUE_TYPE (1 char).

How can i create a SQL script that'll add the above column to the 2 tables?

Have you tried anything? Have you tried searching? – Aleksej Jul 11 '16 at 14:51 — Aleksej, Jul 11 '16 at 14:51

score 1 · Accepted Answer · answered Jul 11 '16 at 14:51

1

alter table t_verify_name add (uc_value_type char(1));
alter table t_verify_address add (uc_value_type char(1));

answered Jul 11 '16 at 14:51

mathguy

1 Answers1