Re: Help! Triggers VS Constraints

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/05/12
Message-ID: <337933b0.5648281@newshost>#1/1

On 9 May 1997 19:58:55 GMT, rram_at_site.gmu.edu (Raghu Ram) wrote:

>Hi all!
>
>Can I write a trigger instead of saying
>"ALTER TABLE TABLE_CHILD
>ADD (CONSTRAINT CONSTRAINT_NAME FOREIGN KEY (COL1)
> REFERENCES TABLE_PARENT );"
You could but you would be writing lots of code to do something that is already done for you.

>Is it true that constraints are actually triggers internally
>in oracle.

No.

>
>Thanks in advance for feedback

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon May 12 1997 - 00:00:00 CDT