The DELETE Statements : Delete « Insert Update Delete « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Insert Update Delete
  3. Delete

The DELETE command provides the means to remove or delete a row from a table.

The Syntax for the DELETE Command

DELETE from table_name
WHERE statement








4.4.Delete
4.4.1.The DELETE Statements
4.4.2.Removing Rows Using the DELETE Statement
4.4.3.Delete all rows from a table
4.4.4.Delete with where clause
4.4.5.Writing a DELETE Statement Containing a Subquery
4.4.6.Delete one row
4.4.7.Deleting Row Data
4.4.8.Delete and subquery
4.4.9.To delete the records of emps whose salary is below the average salary in the department (correlated subquery):