NAME CREATE_TABLE_AS - define a new table from the results of a query SYNOPSIS ... AS query [ WITH [ NO ] DATA ] DESCRIPTION CREATE TABLE AS creates a table and fillsdetail under SELECT (7). NOTES CREATE TABLE AS is functionally similar to SELECT INTO . CREATE ... interpret the INTO clause differently. Furthermore, CREATE TABLE AS offers a supe…CREATE MATERIALIZED VIEW is similar to CREATE TABLE AS , except that it also remembers ... MATERIALIZED VIEW ( ALTER_MATERIALIZED_VIEW (7)), CREATE TABLE AS ( CREATE_TABLE_AS (7)),…INSERT , UPDATE , DELETE , MERGE , CREATE TABLE AS , or EXECUTE statement without letting the command affect ... UPDATE , DELETE , MERGE , VALUES , EXECUTE , DECLARE , CREATE TABLE…other SQL commands, such as CREATE TABLE , as the triggered action. This limitationDROP TABLE ( DROP_TABLE (7)), CREATE TABLE AS ( CREATE_TABLE_AS (7)), CREATE TABLESPACE ( CREATESee the file