Difference between revisions of "Oracle/Select into table"

From YavInWiki
Jump to navigation Jump to search

Revision as of 13:11, 9 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;