Use the SQL DELETE statement to delete an XML document row from an XML column. You can specify WHERE clauses to refine which documents are to be deleted.
Example: The following statements delete all documents that have a value for <ExtendedPrice> greater than 2500.00.
DELETE from sales_tab WHERE invoice_num in (SELECT invoice_num from part_side_tab WHERE price > 2500.00)