DELETE query in Oracle

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.