Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> check statement and assertion

check statement and assertion

From: laststubborn <laststubborn_at_hotmail.com>
Date: 26 Nov 2003 12:07:27 -0800
Message-ID: <6bf8f9e4.0311261207.64bb8d77@posting.google.com>


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 Received on Wed Nov 26 2003 - 14:07:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US