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
]) [WHEREcondition
] [RETURNINGexpression
[,expression
...] INTOdata_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 ...
Get Oracle in a Nutshell 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.