Snippet Name: Create Table INSERT (CTAS) Description: Create a table with the results from a SELECT statement. Also see:» INSERT With Returning Clause » Inserting into SELECT statement » INSERT WITH CHECK OPTION » INSERT FIRST WHEN » INSERT ALL WHEN » INSERT ALL » INSERT WHEN » INSERT: Using A Record » INSERT with Select » INSERT: Multiple Column Table Or View ... » INSERT: Multiple Column Table Or View ... » INSERT: Single Column Table Or View » FORALL Insert » INSERT Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 04th, 2009
Description: Create a table with the results from a SELECT statement.
Also see:» INSERT With Returning Clause » Inserting into SELECT statement » INSERT WITH CHECK OPTION » INSERT FIRST WHEN » INSERT ALL WHEN » INSERT ALL » INSERT WHEN » INSERT: Using A Record » INSERT with Select » INSERT: Multiple Column Table Or View ... » INSERT: Multiple Column Table Or View ... » INSERT: Single Column Table Or View » FORALL Insert » INSERT
CREATE TABLE <table_name> AS <SELECT Statement>; CREATE TABLE t1 AS SELECT store_name, AVG(quantity) qty FROM store join sales using (store_key) GROUP BY store_name;