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 -> Referential Integrity Using View

Referential Integrity Using View

From: Mark & Kristi Wagoner <mwagoner_at_iac.net>
Date: Mon, 6 May 2002 10:34:17 -0400
Message-ID: <ab649a$1047$1@genma.iac.net>


Is there a way to use a view as the target of a foreign key definition? I created a primary key on my view but, since you must specify the DISABLE clause when creating it, I cannot reference it in a table's foreign key clause. I am using 9.0.1

Thanks Received on Mon May 06 2002 - 09:34:17 CDT

Original text of this message

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