...

Database Managment - Oracle

Back to Course

Lesson Description


Lession - #1425 Oracle DELETE


Oracle DELETE

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

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;