Don san Don san - 1 year ago 48
SQL Question

Adding column to existing tables

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

The tables are,


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?

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