Re: why " Alter table emp drop column news_no" doesn't work in Oracle 7.3.* ?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Mon, 10 Dec 2001 22:00:34 GMT
Message-ID: <3C153082.FB714CAD@peasland.com>

You can't drop a column in Oracle 7. That functionality was introduced in Oracle 8i (IIRC).

HTH,
Brian

Lijun Shi wrote:
>
> Hi ,
>
> using Oracle 7.3.x now ( switch fast )
> I did " Alter table emp add ( news_no, number(15,2));" ok .
> but " Alter table emp drop column news_no" doesn't work .
>
> try many times , result is same .
> Also , when I try OCI/C , it gives :
> Connected to ORACLE as scott
> -- ORACLE error when processing OCI function OEXEC, OEXN
> ORA-00905: missing keyword
> Exiting with FAILURE status 1
> when I try OO4O , it gives :
> ErrorNumber()= 8196
>
> " Alter table emp drop column news_no" statement problem ? or others .
>
> thanks
Received on Mon Dec 10 2001 - 16:00:34 CST