RE: Circular FK's
- From: "Knight, Jon" <jknight@xxxxxxxxxxxxxx>
- To: "'kmoore@xxxxxxxxxxxx'" <kmoore@xxxxxxxxxxxx>, Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
- Date: Fri, 4 Nov 2005 11:26:01 -0600
Another option ...
Add the department, assigning an existing employee as manager.
Add the new employee to the newly created department.
Update the new department, assigning the new employee as manager.
Thanks,
Jon Knight
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Keith Moore
Sent: Viernes, 04 de Noviembre de 2005 11:03 a.m.
To: Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Circular FK's
If the column allows nulls, then
Add department with null for the manager
Add employee
Update department with employee as manager
commit;
>
> What do you do when you have a new department that will be headed by a new
> employee?
>
>
--
//www.freelists.org/webpage/oracle-l
-----------------------------------------
The information in this message may be proprietary and/or confidential,
and 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 First Data immediately by
replying to this message and deleting it from your computer.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
