RI Question

From: Doug Stone <dstone_at_res-q.com>
Date: Thu, 5 Nov 1998 09:47:34 -0800
Message-ID: <71soil$6tv@sjx-ixn4.ix.netcom.com>

Our app runs against two DBs: Sybase SQL Anywhere and Oracle.

In SQLA, one may specify, in the table create statement:

FOREIGN KEY emp_f6 (union_id) REFERENCES unions ON DELETE SET NULL

Is it true that ON DELETE SET NULL in Oracle cannot be specified in declarative RI?

Is it also true that ON DELETE SET NULL RI must be implemented in either PL/SQL or SQL triggers?

Thank you,
Doug Received on Thu Nov 05 1998 - 11:47:34 CST