Oracle/Select into table

From YavInWiki
Revision as of 13:11, 9 December 2009 by Andy (talk | contribs) (New page: In Oracle we have no such thing as a "SELECT * INTO table" statement, like we have in T-SQL. But we have alternatives. <source lang="oractle10"> create table new_table as select * fro...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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;