Re: Deep Copy a Record
Date: Fri, 16 May 2008 13:14:46 +0300
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 youremployees 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.
Dixit, Sandeep wrote:
> There must be a good reason why this features is not given.