Database Managment - Oracle

Back to Course

Lesson Description

Lession - #1425 Oracle DELETE


In Oracle, DELETE statement is utilized to eliminate or erase a solitary record or numerous records from a table.

DELETE FROM table_name  
WHERE conditions;   

Oracle Delete Example: On one condition

DELETE FROM customers WHERE name = 'Sohan';

This statement will delete all records from the customer table where name is "Sohan".

Oracle Delete Example: On multiple conditions

DELETE FROM customers  
WHERE last_name = 'Maurya'  
AND customer_id > 2;