Surprising, There must be a good reason why this features is not given. Is there a place to discuss new features or unavailable features or to put forward the suggestions? Sandeep. From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxx] Sent: Thursday, May 15, 2008 9:40 PM To: Dixit, Sandeep; oracle-l@xxxxxxxxxxxxx Subject: RE: Deep Copy a Record Not without writing code, no. -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@xxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx> www.proquest.com <http://www.proquest.com> www.csa.com <http://www.csa.com> ProQuest...Start here. From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dixit, Sandeep Sent: Thursday, May 15, 2008 9:53 AM To: Dixit, Sandeep; oracle-l@xxxxxxxxxxxxx Subject: Deep Copy a Record Is there a way to deep copy a Record into same schema? For example, if I copy a Department, all the Employees under it should be copied having reference to new Department.. and so on.. Sandeep.