Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql statement ERROR please help......
"penny" <boy_66_at_hotmail.com> wrote in message
news:a7c8116a.0107040956.24128126_at_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 Received on Sat Jul 21 2001 - 16:27:28 CDT