oracle sql create table from select

Solutions on MaxInterview for oracle sql create table from select by the best coders in the world

showing results for - "oracle sql create table from select"
Lukas
25 Feb 2017
1-- Copy a table (datas, columns and storage parameters)
2CREATE TABLE my_new_table AS SELECT * FROM my_source_table;
3-- Use NOLOGGING, and PARALLEL if allowed for faster copy
4CREATE TABLE my_new_table
5    PARALLEL 10 NOLOGGING
6AS
7SELECT /*+ parallel(10) */ * FROM my_source_table;
8-- To create an empty table:
9CREATE TABLE my_new_table AS SELECT * FROM my_source_table
10	WHERE rownum = 0;
Mira
14 Oct 2016
1CREATE TABLE my_table AS
2SELECT * FROM another_table t
3WHERE 1=2 --delete the where condition if you also want the data
queries leading to this page
oracle sql duplicate rows resultscreate table oracle queryoracle copy tablecreate table from select oraclecreate table as select 2a from in oracleoracle create table querycreate table as select oraclecreate table select oraclehow to create a copy of an oracle sql tablequery to create table oraclehow to find duplicate data in tableoracle create table select 2a fromoracle sql create table queryoracle create table using selectsql duplicate table with datacreate select oracle sqloracle duplicateoracle sql create table as selectoracle select duplicates in table columncreate table using select in oraclecreate table query oracleduplicate table with new namecreate table with select in oraclecheck duplicate columns in oracleoracle sql create select on tablecreate duplicate table in oraclehow to create a table from another table in oracleoracle sql create table from selectoracle select createoracle create selectcopy a table in sql oracle databaseoracle create table as selectcreate new table using select statement oracleoracle create table from selectcreate table select 2a from oraclecreate table from table oracleoracle create as selecthow to create a copy of an existing table in oraclecreate table oracle from another table with sqlcreate a copy of table in oracle sqlcreate table from another table in oraclecreate table with select statement in oraclecreate a table from a table in oraclecreate select oraclequery on duplicate in oracle sqlcreate table from select in oracle sql developeroracle duplicates from tableoracle sql create table from select