The DELETE statement deletes the tuples of a view that verify a certain condition by updating the underlying data source.
DELETE FROM <view identifier> [ WHERE <condition> ] [ CONTEXT ( <context information> [, <context information>]* ) ] [ TRACE ] <condition> ::= <condition> AND <condition> | <condition> OR <condition> | NOT <condition> | ( <condition> ) | <value> <binary operator> <value> [ , <value> ]* | <value> <unary operator>
For example, the following statement deletes the tuples of the
internet_inc view where the value for the
iinc_id attribute is
greater than 4:
DELETE FROM internet_inc WHERE iinc_id > 4
As a result of executing this statement, the corresponding tuples in the
source database will be deleted in the table associated with the
This statement does not work with Microsoft Excel sources because of limitations in the Excel ODBC Driver provided by Microsoft Windows.
Finally, the DELETE condition can be a subquery when the full DELETE query is delegable to a unique JDBC data source:
DELETE FROM v WHERE (id) in (SELECT B.id FROM v2 B WHERE B.field2 = 'beta');