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 ...