Re: sql statement ERROR please help......

Article View: comp.databases.oracle.server

Article #11

Back to comp.databases.oracle.server Previous Next

#11

From: Sybrand Bakker
Date: Wed, 04 Jul 2001 18:31

44 lines
2175 bytes

"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

Technical Details

Message-ID: <tk6o36hpr5h2c1@beta-news.demon.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!212.74.64.35!colt.net!dispose.news.demon.net!demon!sn-uk-post-01!supernews.com!beta-news.demon.nl!sybrandb.demon.nl!not-for-mail

References: <a7c8116a.0107040956.24128126@posting.google.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fa4f9,cb7915e186f826ca
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: 10de66,cb7915e186f826ca
X-Google-Attributes: gid10de66,public
X-Google-Thread: f5464,cb7915e186f826ca
X-Google-Attributes: gidf5464,public
X-Google-ArrivalTime: 2001-07-04 11:28:55 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!212.74.64.35!colt.net!dispose.news.demon.net!demon!sn-uk-post-01!supernews.com!beta-news.demon.nl!sybrandb.demon.nl!not-for-mail
From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server,borland.public.delphi.database.sqlservers,comp.databases.oracle.tools
Subject: Re: sql statement ERROR please help......
Date: Wed, 4 Jul 2001 20:31:00 +0200
Message-ID: <tk6o36hpr5h2c1@beta-news.demon.nl>
References: <a7c8116a.0107040956.24128126@posting.google.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Complaints-To: abuse@nl.demon.net
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: beta-news.demon.nl 994271333 beta-news:87097 NO-IDENT sybrandb.demon.nl:212.238.21.78
Lines: 47

Reply to Parent Message