Re: create table error with constraint...
From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Thu, 11 Sep 2008 19:01:25 +0200
Message-ID: <gabit3$qvc$1@nntp.fujitsu-siemens.com>
>> Hi!
>> I've got a simple problem with a create table statement:
>> CREATE TABLE HB_ATTRIBUTE (
>> STRINGVALUE VARCHAR2(4000 CHAR),
>> DATEVALUE DATE,
>> CONSTRAINT TCC_HB_ATTRIBUTE_1 CHECK ((STRINGVALUE is null)<>(DATEVALUE is
>> null)) DEFERRABLE INITIALLY DEFERRED);
>> This gives me an "ORA-00907: missing right paranthesis" at the "<>".
>> I have no idea what I'm doing wrong.
>> I'm using 10.2.0.1.0 on linux 32 bit.
>> Can anybody help me out?
Date: Thu, 11 Sep 2008 19:01:25 +0200
Message-ID: <gabit3$qvc$1@nntp.fujitsu-siemens.com>
Dan Blum schrieb:
> Volker Hetzer <firstname.lastname_at_ieee.org> wrote:
>> Hi!
>> I've got a simple problem with a create table statement:
>> CREATE TABLE HB_ATTRIBUTE (
>> STRINGVALUE VARCHAR2(4000 CHAR),
>> DATEVALUE DATE,
>> CONSTRAINT TCC_HB_ATTRIBUTE_1 CHECK ((STRINGVALUE is null)<>(DATEVALUE is
>> null)) DEFERRABLE INITIALLY DEFERRED);
>
>> This gives me an "ORA-00907: missing right paranthesis" at the "<>".
>> I have no idea what I'm doing wrong.
>> I'm using 10.2.0.1.0 on linux 32 bit.
>> Can anybody help me out?
> > You can't compare boolean values that way in SQL. You can do something like this: > > ((decode(stringvalue, NULL, 1, 0) != decode(datevalue, NULL, 1, 0))Will do.
Thanks a lot!
Volker
-- For email replies, please substitute the obvious.Received on Thu Sep 11 2008 - 12:01:25 CDT