Re: multi-table integrity constraints

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 30 Aug 2001 00:41:44 +0200
Message-ID: <toqt2m210kvm50@news.demon.nl>

"christopher lambert" <cjlambert_at_llnl.gov> wrote in message news:1932d1c8.0108290722.37d52446_at_posting.google.com...
> how do you enforce integrity constraints over multiple tables? SQL
> has a feature called ASSERTION, but oracle doesn't support it.

You can do that by means of triggers.
With 'SQL' you probably mean the sql in sqlserver. Just FYI: the language in Oracle is SQL and is SQL92 compliant, as that standard has several levels. Most vendors including Oracle only implemented the lowest level of standardisation: Sybase and Microsoft didn't.

Hth,

Sybrand Bakker,
Senior Oracle DBA

Hth,

Sybrand Bakker, Received on Wed Aug 29 2001 - 17:41:44 CDT