Delete queries In Oracle / SQL

Definition

In SQL, we can delete the records from particular table using the DELETE Statement.

Delete rows in table

DELETE TABLE_NAME; DELETE EMPLOYEE;

Delete all rows in table

DELETE FROM TABLE_NAME; DELETE FROM EMPLOYEE;

Delete selected rows in table

DELETE FROM TABLE_NAME WHERE CONDITION; DELETE FROM EMPLOYEE WHERE E_NAME = 'RAJU';

Delete through select query in table

DELETE FROM (SELECT * FROM TABLE_NAME WHERE CONDITION); DELETE FROM (SELECT * FROM EMPLOYEE WHERE E_NAME = 'RAJU');