Xref: alice comp.databases.oracle.misc:52342
Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!news.new-york.net!newsfeed.wirehub.nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: postbus@sybrandb.demon.nl (Sybrand Bakker)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Add columns to a table with Oracle DB
Date: Wed, 02 Feb 2000 14:01:35 GMT
Message-ID: <38983882.9999408@news.demon.nl>
References: <879a23$avk$1@fbi-news.cs.uni-dortmund.de>
X-Trace: news.demon.nl 949500222 pluto:22895 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@nl.demon.net
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 21

On Wed, 2 Feb 2000 14:05:06 +0100, "Dirk Poppke"
<poppke@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