Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

INSERT

Synopsis

INSERT INTO 
{ table_name[@dblink] 
| table_name PARTITION (partition_name) 
| table_name SUBPARTITION (subpartition_name) 
| view[@dblink]  
}
[table_alias]
[(column[,column...])]
{ VALUES (expr 
  | DEFAULT[,expr 
  | DEFAULT...]
  ) 
| subquery
}
[RETURNING expr[,expr...] INTO data_item[,data_item...]]

Inserts a row of data into a table or view.

Keywords

PARTITION

Specifies that rows be inserted into a partition (named partition) of the specified table.

SUBPARTITION

Specifies that rows be inserted into a subpartition (named subpartition) of the specified table.

view

Name of a view into which rows are to be inserted.

table_alias

Alias (or alternate name) for the table or view. If a table_alias is specified, any columns referenced in the INSERT statement with a specific table reference must be qualified using the table_alias and not the table name.

column

Name(s) of one or more columns in the table or view into which values will be stored. If the VALUES keyword is specified, then for each column specified, a corresponding expr must be specified in the VALUES clause. If the list of column names is omitted, the list is considered to contain all columns of the table or view.

VALUES

Specifies the value(s) to be stored in each column of the row to be inserted. expr can be any valid SQL expression, and there must be exactly as many exprs listed as there are columns specified for the table or view. If no column list is supplied, there must be the same number of expressions as columns in ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page