Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6ALSva20958 for ; Tue, 10 Jul 2001 17:28:57 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f64IGTa05739 for ; Wed, 4 Jul 2001 14:16:29 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f64HnmN04333 for pgsql-sql@postgresql.org; Wed, 4 Jul 2001 13:49:48 -0400 (EDT) (envelope-from news) From: boy_66@hotmail.com (penny) X-Newsgroups: comp.databases.oracle.marketplace, comp.databases.oracle.misc, mailing.database.sql-general, comp.databases.postgresql.sql Subject: sql startment problem PLEASE HELP ..... Date: 4 Jul 2001 10:49:44 -0700 Organization: http://groups.google.com/ Lines: 30 Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-support@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200107/122 X-Sequence-Number: 3909 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.