Deleting Row Data : Delete « Insert Update Delete « Oracle PL/SQL Tutorial

SQL>
SQL>
SQL> CREATE TABLE emp (
  2     empID INT NOT NULL PRIMARY KEY,
  3     Name        VARCHAR(50) NOT NULL);

Table created.

SQL> INSERT INTO emp (empID,Name) VALUES (1,'Victor');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (2,'Bill');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (3,'Mary');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (4,'Jack');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (5,'Peter');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (6,'Tom');

1 row created.

SQL>
SQL>
SQL> DELETE FROM emp WHERE empID > 6;

0 rows deleted.

SQL>
SQL> drop table emp;

Table dropped.

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):