🚀 go-pugleaf

"penny" <boy_66@hotmail.com> wrote in message
news:a7c8116a.0107040956.24128126@posting.google.com...
> 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.


You can't
You need to drop the constraint and recreate it.
Please try to consult the sql reference manual before posting these typing
of questions.

Regards,

Sybrand Bakker, Senior Oracle DBA

Yes, you only can change constraint_state in alter table modify
constraints.. clause.
BUT if you really need to change that in one SQL here there is:
 (connect as user who got privileges to sys obj)


UPDATE sys.cdef$
   SET condition = New_Codition_Here
 WHERE con# = (
   select c.con#
     from sys.obj$ o, sys.cdef$ c, sys.con$ oc
    where c.obj# = o.obj#
      and o.name = 'TTT'
      and oc.name = 'E'
      and oc.con# = c.con#
     );

Have Fun.


U�ytkownik "Sybrand Bakker" <postbus@sybrandb.demon.nl> napisa� w wiadomo�ci
news:tk6o36hpr5h2c1@beta-news.demon.nl...
>
> "penny" <boy_66@hotmail.com> wrote in message
> news:a7c8116a.0107040956.24128126@posting.google.com...
> > 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.
>
>
> You can't
> You need to drop the constraint and recreate it.
> Please try to consult the sql reference manual before posting these typing
> of questions.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>