Oracle in a Nutshell

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