INSERT

INSERT INTO {schema.{table[{@dblink] |
                       table PARTITION (partition) |
                       table SUBPARTITION (subpartition) |
                       view[@dblink] | 
            }[table_alias]
[(column[,column...])
{VALUES (expr[,expr...]) |
 subquery
}
[RETURNING expression[,expression...] INTO data_item[,data_item...]]

Inserts a row of data into a 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.

Keywords

schema

The name of the schema containing the table or view into which rows are to be inserted. If omitted, the current userid is assumed.

table

The name of a table into which rows are to be inserted.

dblink

The name of a database link used to access the table or view into which rows are to be inserted.

PARTITION

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

SUBPARTITION

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

view

The name of a view into which rows are to be inserted.

table_alias

Specifies an alias (or alternate name) for the table or view.

column

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

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.