sql statement ERROR please help......
From: penny <boy_66_at_hotmail.com>
Date: Sat, 21 Jul 2001 21:27:23 GMT
Message-ID: <a7c8116a.0107040956.24128126_at_posting.google.com>
Date: Sat, 21 Jul 2001 21:27:23 GMT
Message-ID: <a7c8116a.0107040956.24128126_at_posting.google.com>
[Quoted] 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 - 23:27:23 CEST