Difference between revisions of "Oracle/Select into table"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
create table new_table as select * from old_table; | create table new_table as select * from old_table; | ||
</source> | </source> | ||
[[Category:Oracle]] | |||
Latest revision as of 11:34, 10 December 2009
In Oracle we have no such thing as a "SELECT * INTO table" statement, like we have in T-SQL. But we have alternatives.
create table new_table as select * from old_table;