Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: why " Alter table emp drop column news_no" doesn't work in Oracle 7.3.* ?
drop column is feature in Oracle 8....
"Lijun Shi" <eq418_at_freenet.carleton.ca> wrote in message
news:9uvrq8$fne$1_at_freenet9.carleton.ca...
> 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 Wed Dec 12 2001 - 23:17:59 CST