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: why " Alter table emp drop column news_no" doesn't work in Oracle 7.3.* ?

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

From: Simon <sychan98_at_excite.com>
Date: Thu, 13 Dec 2001 13:17:59 +0800
Message-ID: <9v9do2$qeq1@rain.i-cable.com>


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

Original text of this message

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