OracleDELETE删除记录sql语句用法.pdfVIP

语法与其它的 sql 数据库教程是一样的，如下 DELETE FROM COURSES WHERE COURSE_DESIGNA TER = Java110 按条件比较复杂的操作方法 DELETE FROM CLASSCONVENINGS WHERE CLASSES_NUM_FK gt; 4 AND CLASS_CONVENE_DATE = TO_DA TE(2006-02-15 00:00:00, YYYY-MM-DD HH24:MI:SS) AND CLASS_LOCATION_FK = Seattle-Training Room 1 下面来看个详细的实例 SQLgt; -- create demo table SQLgt; create table Employee( 2 ID V ARCHAR2(4 BYTE) NOT NULL, 3 First_Name VARCHAR2(10 BYTE), 4 Last_Name VARCHAR2(10 BYTE), 5 Start_Date DA TE, 6 End_Date DATE, 7 Salary Number(8,2), 8 City VARCHAR2(10 BYTE), 9 Description V ARCHAR2(15 BYTE) 10 ) 11 / Table created. SQLgt; SQLgt; -- prepare data SQLgt; insert into Employee(ID, First_Name, Last_Name, Start_Date, End_Date, Salary, City, Description) 2 values (01,Jason, Martin, to_dateYYYYMMDD), to_dateYYYYMMDD), 1234.56, Toronto, Programmer) 3 / 1 row created. SQLgt; insert into Employee(ID, First_Name, Last_Name, Start_Date, End_Date, Salary, City, Description) 2 values(02,Alison, Mathews, to_dateYYYYMMDD), to_dateYYYYMMDD), 6661.78, Vancouver,Tester) 3 / 1 row created. SQLgt; insert into Employee(ID, First_Name, Last_Name, Start_Date, End_Date, Salary, City, Description) 2 values(03,James, Smith, to_dateYYYYMMDD), to_dateYYYYMMDD), 6544.78, Vancouver,Tester) 3 / 1 row created. SQLgt; insert into Employee(ID, First_Name, Last_Name, Start_Date, End_Date, Salary, City, Description) 2 values(04,Celia, Rice, to_dateYYYYMMDD), to_dateYYYYMMDD), 2344.78, Vancouver,Manager)