Oracle SQL DELETE Examples

DELETE - Row

Delete a row of data. 

DELETE FROM COURSES
WHERE  COURSE_DESIGNATER = 'Java110' 
/

COMMIT WORK ;

DELETE - Multiple rows of data

Delete multiple rows of data. Be careful!

DELETE FROM CLASSCONVENINGS
WHERE      CLASSES_NUM_FK      > 4  
  AND CLASS_CONVENE_DATE = TO_DATE('2006-02-15 00:00:00', 
                                   'YYYY-MM-DD HH24:MI:SS') 
  AND CLASS_LOCATION_FK   = 'Seattle-Training Room 1'
  
 Collapse All    Expand All
Custom Search

Oracle Information and Resources