I take it by "deep copy" you mean the object operation. Any "deep copy" requires a defined constructor. The reasonable presumption on an Oracle list if you start talking about Department and Employees is that you are making a reference to the example database. In that context Department is a table, not a user defined object with a pre-defined "clone" constructor. In that context Mr. Bobak is exactly correct. There is also a pretty long section in the Oracle manuals since 8.0 beta about what Oracle does and does not handle regarding objects defined in Oracle. If you want to define and manipulate objects natively in Oracle as opposed to in an object oriented programming language using an Oracle database for storage, look there for the release you're at. I don't know whether there are any experienced users of the native Oracle objects on this particular list. As for enhancements, after you digest what is and is not there for objects defined in Oracle, there are defined enhancement processes available to the members of IOUG, OAUG, and ODTUG, and if you can join the Oracle Mix forum you can make suggestions there. Regards, mwf _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dixit, Sandeep Sent: Friday, May 16, 2008 5:18 AM To: Bobak, Mark Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: Deep Copy a Record 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 <snip> Sandeep.