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

Home -> Community -> Usenet -> comp.databases.theory -> Can ref_int be defined with standard SQL at all?

Can ref_int be defined with standard SQL at all?

From: DT <denis.trcek_at_ijs.si>
Date: Tue, 16 Jan 2001 10:22:13 +0100
Message-ID: <3A6412C4.424B8B59@ijs.si>

Can anybody please let me know how to set up referential integrity using standard SQL - I don't want to deal with tricks like MS SQL Server 7.X triggers...

So, the bottom line question is: What are the standard SQL statements to
make ref. int. between e.g. the following two relations (Customer_ID is a foreign key in the second table):

(#Customer_ID, Name, Surname) and (#Item_ID, #Customer_ID, Quantity).

Thank you for your answer in advance. D. Trcek Received on Tue Jan 16 2001 - 03:22:13 CST

Original text of this message

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