create table error with constraint...
From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Fri, 25 Jul 2008 16:28:22 +0200
Message-ID: <g6cnu5$f1c$1@nntp.fujitsu-siemens.com>
Date: Fri, 25 Jul 2008 16:28:22 +0200
Message-ID: <g6cnu5$f1c$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 isnull)) 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?
Lots of Greetings!
Volker
-- For email replies, please substitute the obvious.Received on Fri Jul 25 2008 - 09:28:22 CDT