Delete rows that contain row types

When a row contains a column that is defined on a ROW type, you can use dot notation to specify that the only rows deleted are those that contain a specific field value. For example, the following statement deletes only those rows from the employee table in which the value of the city field in the address column is San Jose:

DELETE FROM employee
   WHERE address.city = 'San Jose';