Oracle DELETE删除记录sql语句用法

语法与其它的sql是一样的，如下
DELETE FROM COURSES
WHERE  COURSE_DESIGNATER = 'Java110'

按条件比较复杂的操作方法

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'
 

下面来看个详细的实例

删除指定的内容