If NEW_TABLE already exists then ...
insert into new_table select * from old_table
/
If you want to create NEW_TABLE based on the records in OLD_TABLE ...
create table new_table as select * from old_table
/
SELECT INTO using Oracle
最新推荐文章于 2021-09-14 10:10:17 发布