Creating assertions on oracle 10g

From: Pedda <hemanth.6996_at_gmail.com>
Date: Sat, 31 Oct 2009 03:50:41 -0700 (PDT)
Message-ID: <528ffdbc-dbf2-4c9f-ab56-1f802c0b24ac_at_v37g2000prg.googlegroups.com>

Hi,
I am working on Oracle 10g Database.
I am trying to create an assertion in Oracle 10g but it is displaying an error message
I use the following command to create an assertion in 10g but it is not working.

CREATE ASSERTION AST1(SELECT COUNT(*) FROM EMP + SELECT COUNT(*) FROM DEPT>SELECT COUNT(*) FROM EMP_DEPT); Please let me know any changes to the above command so that the above assertion works in Oracle10g

Thanks,
Hemanth Received on Sat Oct 31 2009 - 05:50:41 CDT