Re: How to get back useful error messages?

tkyte_at_us.oracle.com wrote:
> create table t1 ( x int
> constraint "t1.x cannot be null" check ( x is not null )
> );

This works fine for NOT NULL, but what about UNIQUE? If I do:

create table t1 (x int constraint "x must be unique" check (x is unique));

I get:

ORA-00908: missing NULL keyword

--
Roy Smith <roy_at_popmail.med.nyu.edu>
New York University School of Medicine Received on Tue Sep 15 1998 - 10:52:35 CDT