RE: Circular FK's

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 4 Nov 2005 18:26:05 +0100
Message-Id: <20051104172605.B9800217C9C@turing.freelists.org>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael.Coll-Barth_at_VerizonWireless.com Sent: Friday, November 04, 2005 17:39
To: oracle-l_at_freelists.org
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_at_naturaljoin.nl] 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 04 2005 - 11:28:19 CST