Re: Deep Copy a Record

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Fri, 16 May 2008 13:14:46 +0300
Message-id: <482D5E96.5040202@inter.net.il>

I think that this kind of operation depends on your requirements. Example: department and employees.
When you copy department do you want all the employees:

1) Moved to the new department.
2) Remain in the old department.
3) Copied to the new department, creating double entries in your 

employees file, leaving you to pay double salary until someone caught this error (if your employees definition allow double entries). Or Oracle needs to replicate the record while updating end_work field in the old record and start_work field in the new record. 4) Let take this to another level. You also have department/employee/date/hour worked. Should oracle update this file also or do you want to leave old data alone.

It is just too complicated.

Adar Yechiel
Rechovot, Israel

Dixit, Sandeep wrote:
>
> Surprising,
>
> There must be a good reason why this features is not given.
>
>
>
>

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

Received on Fri May 16 2008 - 05:14:46 CDT