Home » Other » General » SQL enhancement: assertions
SQL enhancement: assertions [message #651528] Thu, 19 May 2016 10:33 Go to next message
John Watson
Messages: 8880
Registered: January 2010
Location: Global Village
Senior Member
I've just been reading this,


it states that assertions are part of the SQL92 standard and may be implemented by Oracle in future. Is anyone familiar with their use in some other product? The only equivalent I can think of in Oracle (apar from horribly complicated and badly performing and unreliable trigger based solutions) is the Oracle Rules Engine, which is no longer supported.

Re: SQL enhancement: assertions [message #651534 is a reply to message #651528] Thu, 19 May 2016 13:28 Go to previous message
Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The only equivalent I can think of in Oracle .. s the Oracle Rules Engine

Which I showed here sometime ago does not work in multi-user environment.
There is also RuleGen, see this topic (that you ended Smile ).

Previous Topic: Searching Objects Relationship in Huge DB
Next Topic: Launch Event: Oracle Database 12.2
Goto Forum:

Current Time: Mon Oct 02 03:01:09 CDT 2023