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: "Alter table" syntax command ?

Re: "Alter table" syntax command ?

From: Gitte Tøgersen <g.togersen_at_sondagsavisen.dk>
Date: Tue, 23 Jun 1998 09:53:40 +0200
Message-ID: <6mnn28$68s$1@news.uni-c.dk>


Hi Patrick !

You're missing the brackets...

alter table MY_TABLE
add (NEW_COLL number(length));

This should do it....

Kind regards

Gitte Tøgersen
Denmark



Email: danskdata_at_hotmail.com
Patrick Marcouly skrev i meddelelsen
<6mm6do$ark$1_at_pegase.production.axime.fr>...
>Hi all.
>
>I'm an horrible newbie on Oracle and I don't have any docs.
>I altered a table with the command :
>
>alter table MY_TABLE add NEW_COLL number;
>
>It was a bad idea and now I'm trying to drop this NEW_COLL from my table. I
>used several commands but all failed because of bad syntax.
>
>What is the command for simply drop a column from a table ?
>
>
Received on Tue Jun 23 1998 - 02:53:40 CDT

Original text of this message

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