Oracle Tutorial

Delete Statement Examples

Example 1

Delete From customers c
Where c.insolvency = 'YES' ;

Example 2

Delete From send_sms s
Where s.id_invoice IN (Select i.invoice_id
From invoices i
Where i.amount <= 1
And i.invoice_id = s.invoice_id
);