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'