Re: Appending columns
From: Greg Tupper <gtupper_at_monkfish.nosc.mil>
Date: Fri, 25 Feb 1994 08:04:39 GMT
Message-ID: <1994Feb25.080439.4937_at_nosc.mil>
Date: Fri, 25 Feb 1994 08:04:39 GMT
Message-ID: <1994Feb25.080439.4937_at_nosc.mil>
alter table {tablename} add {column_name} (data type} (width);
for example
alter table country_code add flag_color varchar2(20);
I may be a little off. It might be
alter table country_code add (flag color varchar2(20));
or
alter table country_code add flag_color (varchar2(20));
greg Tupper
Saic Commsystems
gtupper_at_nosc.mil
Received on Fri Feb 25 1994 - 09:04:39 CET