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: how to modify a CHECK column-constrait ?

Re: how to modify a CHECK column-constrait ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 23 Jul 1999 16:51:24 +0800
Message-ID: <37982D0C.4955@yahoo.com>


Ruud Schmeitz wrote:
>
> Hi readers,
>
> After working for more than 10 year with DEC's (now Oracle's) Rdb, we're
> now converting our databases to Oracle.
>
> I've found 2 annoying problems. According to the SQL Reference Manual
> (Oracle 7.3 and 8.0) it is not possible to:
> 1. modify an existing CHECK column-constraint;
> 2. drop a column from a table;
>
> Is this really true (I just hope it ain't) ?
> Are there any work-arounds ?
>
> Kind regards and TIA,
>
> ============================================================
>
> "Live Long and Prosper" - Spock
> "And let Wisdom be your Guide" - Spock's brother
>
> Ruud Schmeitz
> Universiteit Maastricht

Drop column appears in 8i.

alter table modify ... has been around since Noah was a lad...

Cheers
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Jul 23 1999 - 03:51:24 CDT

Original text of this message

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