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