DELETE WHERE « Insert Delete Update « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Insert Delete Update
  3. DELETE WHERE
1.WHERE clause is used to control which rows are affected by the DELETE statement
2.Delete command with conditions
3.Delete all records in TableA whose data in field1 and field2 DO NOT match the data in fieldx and fieldz of TableB
4.Delete clause with sub query
5.Delete statement with where clause and varchar2 type column
6.Delete one row