Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL code in constraints?

Re: PL/SQL code in constraints?

From: <sybrandb_at_yahoo.com>
Date: 30 May 2005 05:47:51 -0700
Message-ID: <1117457271.685833.3600@g47g2000cwa.googlegroups.com> 





Constraints signify relationships between entities.
Consequently it is not possible to add any procedural logic.
You'll need to use triggers.


However note, you should avoid replacing constraints completely by
triggers.


Enforcing integrity by means of triggers is about 8 times slower.


--
Sybrand Bakker
Senior Oracle DBA


Received on Mon May 30 2005 - 07:47:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US