Re: check statement and assertion

laststubborn wrote:

> I am trying to write a constraint in Oracle 9 with SQL statement.
> During the creation of the table I have written
>
> check(exist
> (select line_no, count(*)
> from sections
> group by line_no
> having count(*)<=4));
>
> but this is not working. Is there anyway to get it worked?
>
> Thank you

What is the origin of this syntax? Where did you find this?

I ask because I've never seen anything like it in Oracle and just looked all over tahiti.oracle.com and otn.oracle.com and can not find any syntax even remotely resembling this.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)