Difference between revisions of "Oracle/Select into table"
Jump to navigation
Jump to search
(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...) |
|||
| Line 1: | Line 1: | ||
In Oracle we have no such thing as a "SELECT * INTO table" statement, like we have in [[T-SQL]]. But we have alternatives. | 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=" | <source lang="oractle11"> | ||
create table new_table as select * from old_table; | create table new_table as select * from old_table; | ||
</source> | </source> | ||
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;