Creating assertions on oracle 10g

From: Pedda <>
Date: Sat, 31 Oct 2009 03:50:41 -0700 (PDT)
Message-ID: <>

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

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

Original text of this message