Oracle CTAS (create table as select) is a convenient way to create a new table based on an existing table.
SQL> select * from tbl_test; NUM ---------- 1 2 SQL> create table tbl_test2 as select * from tbl_test; Table created. SQL> select * from tbl_test2; NUM ---------- 1 2In SQL Server, instead of using CTAS, we use "select.. into new_table from old_table" to create a new table based on old table.
select * into tbl_test2 from tbl_test;
Post a Comment