DELETE query in Oracle

by

ORACLE DELETE
To remove or delete a single record or multiple records from a table, Oracle DELETE statement is used.
Syntax: To delete all rows from a table. 

DELETE FROM table_name

Syntax: To delete specific rows from a table. 

DELETE FROM table_name  
WHERE conditions;

Parameters:
table_name: It is used to specify the name of the table to be deleted.
conditions: It is used to specify the conditions to be strictly fulfilled for the deletion process to take place.

Example: Deleting one row from a table. 

 
DELETE FROM students
WHERE
    student_age = 10
    AND student_id = 1;

Output: 

1 row deleted.

Explanation:
The ‘students’ is an already existing table. The student_age and the student_id are the two columns of the ‘students’ table. Here, we are deleting a row whose student_age is 10 and student_id is 1.

Example: Deleting multiple rows from a table. 

DELETE FROM students
WHERE
    student_age = 10

Output: 

30 rows deleted.

Explanation:
The ‘students’ is an already existing table. The student_age is a column of the ‘students’ table. Here, we are deleting all rows whose student_age is 10.

Example: Deleting all rows from a table. 

DELETE FROM students

Output: 

100 rows deleted.

Explanation:
The ‘students’ is an already existing table. Here, we are deleting all rows of the table.