Re: How to tell what delete_rule in user_constraints

From: <yong321_at_yahoo.com>
Date: 24 Aug 2005 19:49:47 -0700
Message-ID: <1124938187.620795.325850@z14g2000cwz.googlegroups.com>

> So my question is who to distinguish between "ON DELETE SET NULL" and
> the really "NO ACTION" constraints.

Dominica,

Here's my test:

SQL> alter table child add constraint fk foreign key (a) references parent on delete set null;

Table altered.

SQL> select delete_rule from user_constraints where constraint_name = 'FK';

DELETE_RU

---

SET NULL SQL> select * from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production ...

Please tell us the version of your database and preferably show your sqlplus screen shot.

Yong Huang Received on Wed Aug 24 2005 - 21:49:47 CDT