When a row contains a column that is defined on a collection type, you can search for a particular element in a collection and delete the row or rows in which that element is found. For example, the following statement deletes rows in which the direct_reports column contains a collection with the element Baker:
DELETE FROM manager WHERE 'Baker' IN direct_reportsHome | [ Top of Page | Previous Page | Next Page | Contents | Index ]