CREATE_TABLE_AS (l)
Creates a new table
SYNOPSIS
CREATE TABLE table [ (column [, ...] ) ]
AS select_clause
table
The name of a new table to be created.
column
The name of a column. Multiple column names can be specified using
a comma-delimited list of column names.
select_clause
A valid query statement. Refer to SELECT for a description of the
allowed syntax.
Refer to CREATE TABLE
and SELECT for a summary of possible output
messages.
DESCRIPTION
CREATE TABLE AS enables a table to be created
from the contents of an existing table.
It is functionality equivalent to
select_into(l),
but with perhaps a more direct syntax.
|