AW: Deep Copy a Record

Surprising that you expect Oracle to do this job...
If you could try to figure out what has to be coded to handle each and every
possible way of implementation and dependencies of tables, then you could
have a (very small) glimpse what Oracle has to deal with if they implemented
And we did not talk about referential integrity or partitioning, etc which
have to be maintained, too.
my 2 cents,


Von: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im
Auftrag von Dixit, Sandeep
Gesendet: Freitag, 16. Mai 2008 11:18
An: Bobak, Mark
Cc: oracle-l@xxxxxxxxxxxxx
Betreff: RE: Deep Copy a Record


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?





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
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
 <mailto:mark.bobak@xxxxxxxxxxxxxxx> mark.bobak@xxxxxxxxxxxx

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..





Other related posts: