Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Add a Column to an Existing Table?
"Sted Alana" <Sted_Alana_at_hotmail.com> wrote in message news:<3cd7cb00_1_at_news.iprimus.com.au>...
> Consider a table foo, how do i add a column named fieldfoo1 to it?
>
> im not sure but i believe it has something to do with update followed by an
> alter.
>
> Any help appreciated.
It's simply:
alter table X add <Column_name> <data_type>;
For example: alter table emp add contact# number(10,0);
GZ Received on Tue May 07 2002 - 18:04:21 CDT