Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to Add a Column to an Existing Table?

Re: How to Add a Column to an Existing Table?

From: Grace Kutamundra <lydian_third_at_yahoo.com>
Date: 7 May 2002 16:04:21 -0700
Message-ID: <c168d7a.0205071504.284acd6a@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US