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