Re: Deep Copy a Record
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- 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 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.
Other related posts:
