Oracle Delete

Oracle Delete statement

How to use the DELETE statement to delete rows from table.

Oracle Delete syntax

DELETE FROM table_name
[ WHERE condition ];

Delete example

DELETE CUSTOMERS 
WHERE ID=1;

DELETE CUSTOMERS 
WHERE ID=2 
AND NAME='Address 2B';

DELETE CUSTOMERS;