Watch out on the copy - it works great unless you have BLOBS. I got bit on this one!

>>> "Todd Pepling " <oracledba-ezmlmshield-x18738280.[Email address protected] 8/30/2007 1:51:45 PM >>>
COPY command is used to copy data from one table to another table
(destination table can be in the same database or another database).
Following is an example of copying data from one table to another table in
the same database:

COPY FROM scott/[Email Address Removed]
CREATE STUDENT (STUDENT_ID, STUDENT_NAME)
USING SELECT ROLL_NO, NAME FROM STUDENTS
WHERE CLASS_ID= 12;




Oracle LazyDBA home page