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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Add columns to a table with Oracle DB

Re: Add columns to a table with Oracle DB

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 02 Feb 2000 14:01:35 GMT
Message-ID: <38983882.9999408@news.demon.nl> 





On Wed, 2 Feb 2000 14:05:06 +0100, "Dirk Poppke"
<poppke_at_iug.cs.uni-dortmund.de> wrote:



>Hi everybody!


>


>Is there a way to add a new column to an existing Table?


>


>Thanks,


>Dirk


>


>




Alter table <table_name> add (<column_name> <datatype> [NOT NULL])



RTFM




Hth,




Sybrand Bakker, Oracle DBA
Received on Wed Feb 02 2000 - 08:01:35 CST












Original text of this message













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