oracle中删除yuj_Oracle数据库删除语句DELETE的一般性用法

语法与其它的

sql

数据库教程是一样的，如下

DELETE FROM COURSES

WHERE COURSE_DESIGNA

TER = 'Java110'

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

DELETE FROM CLASSCONVENINGS

WHERE CLASSES_NUM_FK > 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'

下面来看个详细的实例

SQL> -- create demo table

SQL> create table Employee(

2 ID V

ARCHAR2(4 BYTE) NOT NULL,

3 First_Name V

ARCHAR2(10 BYTE),

4 Last_Name V

ARCHAR2(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.

SQL>

SQL> -- prepare data

SQL>

insert

into

Employee(ID,

First_Name,

Last_Name,

Start_Date,

End_Date,

Salary,

City, Description)

2

values

('01','Jason',

'Martin',

to_date('19960725','YYYYMMDD'),

to_date('20060725','YYYYMMDD'), 1234.56, 'Toronto', 'Programmer')

3 /

1 row created.

SQL>

insert

into

Employee(ID,

First_Name,

Last_Name,

Start_Date,

End_Date,

Salary,

City, Description)

2

values('02','Alison',

'Mathews',

to_date('19760321','YYYYMMDD'),

to_date('19860221','YYYYMMDD'), 6661.78, 'Vancouver','Tester')

3 /

1 row created.

SQL>

insert

into

Employee(ID,

First_Name,

Last_Name,

Start_Date,

End_Date,

Salary,

City, Description)

2

values('03','James',

'Smith',

to_date('19781212','YYYYMMDD'),

to_date('19900315','YYYYMMDD'), 6544.78, 'Vancouver','Tester')

3 /