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

https://community.oracle.com/ideas/13028

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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
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: Fri Mar 29 02:13:16 CDT 2024