RE: Circular FK's

From: <Michael.Coll-Barth_at_VerizonWireless.com>
Date: Fri, 4 Nov 2005 11:39:24 -0500
Message-Id: <20051104163938.5A7F8216A41@turing.freelists.org>

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.

---

The information contained in this message and any attachment may be proprietary, confidential, and privileged or subject to the work product doctrine and thus protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to this message and deleting it and all copies and backups thereof. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 04 2005 - 10:44:28 CST