«Back to Home

Oracle Jump Start
Topics

How To Use Delete Statement In OraclePLSQL

Description
 
This statement is used to delete a single record or multiple records from a table i.e. called delete statement in Oracle/PLSQL.
 
Syntax
The syntax for the delete statement is given below-
  1. Delete from table  
  2. where conditions;  
Example
 
The example, given below, has one condition in the delete statement.
  1. Delete from department  
  2. where Dept_name= 'sales';  
1
2 
 
Example
 
This example has two conditions in the delete statements.
  1. delete from department  
  2. where Dept_name= 'SALES DEPT'  
  3. AND Dept_id>20;  
3 
 
Summary
 
Thus, we learnt, delete statement is used to delete a single record or multiple records from a table and how to use this command in Oracle with an example.