Re: Creating assertions on oracle 10g

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Sat, 31 Oct 2009 04:58:57 -0700 (PDT)
Message-ID: <75c6a379-bbc3-417b-82f6-1238ed4e4953_at_s15g2000yqs.googlegroups.com>



On Oct 31, 1:50 pm, Pedda <hemanth.6..._at_gmail.com> wrote:
> 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

Why do you expect it to work? In which Oracle SQL reference manual did you find this CREATE ASSERTION command? Even 11g R2 doesn't have it, nor any previous release. Indeed, it's part of the SQL-92 standard, but to the best of my knowledge, no commercial RDBMS product ever implemented it. You can possibly implement an equivalent to assertion in Oracle as a statement level trigger or a check constraint on a refresh-on-commit materialized view.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Sat Oct 31 2009 - 06:58:57 CDT

Original text of this message