RE: Circular FK's

in the absence of multiple assignments, use a deffered constraint as a
workaround :-)

kind regards,

Lex.
 
---------------------------------------------------------------------
Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html
---------------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
Sent: Friday, November 04, 2005 17:39
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Circular FK's


What do you do when you have a new department that will be headed by a new
employee?  


-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx]
Sent: Friday, November 04, 2005 10:03 AM
To: Post, Ethan; 'Oracle-L Freelists'
Subject: RE: Circular FK's

Hi Ethan,

sure, this is quite common.

I have such a construct in the demo tables of my SQL book:
each employee works for a certain existing department, and each department has
an existing employee as its manager.

BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD

Other related posts: