Oracle DELETE StatementIn Oracle, DELETE statement is used to remove or delete a single record or multiple records from a table. Syntax Parameters1) 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 conditionThis statement will delete all records from the customer table where name is "Sohan". Oracle Delete Example: On multiple conditionsThis statement will delete all records from the customers table where the last_name is "Maurya" and the customer_id is greater than 2. Next TopicOracle Truncate Table |