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

Home -> Community -> Usenet -> c.d.o.server -> sql statement ERROR please help......

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@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.
Received on Sat Jul 21 2001 - 16:27:23 CDT

Original text of this message

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