Oracle Copy

Option #1

INSERT INTO testtable2
USING SELECT field1, field2 FROM testtable;
exit;

Option #2

CREATE TABLE testtable2 AS
SELECT field1, field2
FROM testtable
WHERE field2 > 5;
exit;

History Comments