sql statement ERROR please help......

Article View: comp.databases.oracle.server

Article #12

Back to comp.databases.oracle.server Previous Next

#12

From: penny
Date: Wed, 04 Jul 2001 17:56

31 lines
1571 bytes

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.

Technical Details

Message-ID: <a7c8116a.0107040956.24128126@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fa4f9,cb7915e186f826ca,start
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: 10de66,cb7915e186f826ca,start
X-Google-Attributes: gid10de66,public
X-Google-Thread: f5464,cb7915e186f826ca,start
X-Google-Attributes: gidf5464,public
X-Google-ArrivalTime: 2001-07-04 10:56:21 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!postnews1.google.com!not-for-mail
From: boy_66@hotmail.com (penny)
Newsgroups: comp.databases.oracle.server,borland.public.delphi.database.sqlservers,comp.databases.oracle.tools
Subject: sql statement ERROR please help......
Date: 4 Jul 2001 10:56:20 -0700
Organization: http://groups.google.com/
Lines: 31
Message-ID: <a7c8116a.0107040956.24128126@posting.google.com>
NNTP-Posting-Host: 130.130.68.19
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 994269381 5721 127.0.0.1 (4 Jul 2001 17:56:21 GMT)
X-Complaints-To: groups-support@google.com
NNTP-Posting-Date: 4 Jul 2001 17:56:21 GMT