Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: sql startment problem PLEASE HELP .....

Re: sql startment problem PLEASE HELP .....

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Sat, 21 Jul 2001 22:57:12 GMT
Message-ID: <3B43591F.5AEEBDB5@cgi.ca>

Hi Penny,

I hope someone proves me wrong, but I don't think you can modify a constraint like that....I believe you have to drop it and recreate it.

Steve

penny wrote:

> Hi all,
>
> I am using Oracle8i Enterprise Edition in window 2000
>
> my problem as following
>
> ~~~~~~~~~~~~~~~~~~~~~
>
> SQL> create table ttt
> 2 ( name varchar2(100)
> 3 ,
> 4 constraint e check (name = lower(name)));
>
> Table created.
>
> SQL> alter table ttt
> 2 modify constraint e
> 3 check (name = upper(name));
> check (name = upper(name))
> *
> ERROR at line 3:
> ORA-00933: SQL command not properly ended
>
>
> How can I modify constraint e ????
>
> thanks.
Received on Sat Jul 21 2001 - 17:57:12 CDT

Original text of this message

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