Easy does it: Code: CREATE TABLE TableB AS SELECT ROWNUM TableB_pk, TableA.* FROM TableA;
CREATE TABLE TableB AS SELECT ROWNUM TableB_pk, TableA.* FROM TableA;
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Forum Rules
Ctas?
Reply With Quote