Published by : Obay Salah , December 1, 2024

In Oracle, DELETE statement is used to remove or delete a single record or multiple records from a table.

Syntax

DELETE FROM table_name  
WHERE conditions;   

Parameters

1- table_name: It specifies the table which you want to delete.

2- conditions: It specifies the conditions that must met for the records to be deleted.


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;  

This statement will delete all records from the customers table where the last_name is "Maurya" and the customer_id is greater than 2.



Tags : SQL

You May Also Like

Comments

no comment yet!