Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E25519-05 |
|
|
PDF · Mobi · ePub |
The PL/SQL extension to the SQL INSERT
statement lets you specify a record name in the values_clause
of the single_table_insert
instead of specifying a column list in the insert_into_clause
. Effectively, this form of the INSERT
statement inserts the record into the table; actually, it adds a row to the table and gives each column of the row the value of the corresponding record field.
LNPLS1613Topics
LNPLS1614insert_into_clause ::=
LNPLS1615values_clause ::=
LNPLS1616insert_into_clause
LNPLS1617dml_table_expression_clause
Typically a table name. For complete information, see Oracle Database SQL Language Reference.
LNPLS1618t_alias
An alias for dml_table_expression_clause
.
LNPLS1633values_clause
LNPLS1634record
Name of a record variable of type RECORD
or %ROWTYPE
. record
must represent a row of the item explained by dml_table_expression_clause
. That is, for every column of the row, the record must have a field with a compatible data type. If a column has a NOT
NULL
constraint, then its corresponding field cannot have a NULL
value.
LNPLS1635In this chapter:
LNPLS1636In other chapters: