Name
DELETE
Synopsis
DELETE [FROM]
{ table_name[@dblink]
| table_name PARTITION (partition_name)
| table_name SUBPARTITION (subpartition_name)
| view[@dblink]
| snapshot[@dblink]
| [(subquery)]
| [TABLE(subquery)]
}
[table_alias] |
ONLY (
{ table_name[@dblink]
| table_name PARTITION (partition_name)
| table_name SUBPARTITION (subpartition_name)
| view[@dblink]
| snapshot[@dblink]
| [(subquery)]
| [TABLE(subquery)]
}
[table_alias])
[WHERE condition]
[RETURNING expression[,expression ...] INTO data_item[,data_item ...]]Deletes rows from a table, view, or snapshot.
Keywords
- FROM
Optional keyword to aid readability.
- PARTITION
Specifies that rows are to be deleted from a partition (named partition) of the specified table.
- SUBPARTITION
Specifies that rows are to be deleted from a subpartition (named subpartition) of the specified table.
- subquery
Specifies a subquery, which determines the rows that are candidates for deletion. See the SELECT entry for more information on subqueries.
- TABLE subquery
Specifies a SELECT statement that returns a single column value, which must be a nested table. The TABLE keyword informs Oracle that the value is a collection, not a scalar value.
- table_alias
Specifies an alias (or alternate name) for the table, view, or subquery. If a table_alias is specified, any columns referenced in the DELETE statement with a specific table reference must be qualified using the table_alias and not the table name.
- ONLY
This clause is relevant only for views, and is used if the view ...