单项选择题
以下是INVENTORY(库存)表中每一列的详细定义:
Column Name | ID_HUMBER | DESCRIPTION | MANUFACTURER_ID | QUANTITY | PRICE | ORDER_DATE |
Key Type | PK | | FK | | | |
Nulls/Unique | HN, U | NN | NN | | | |
FK Table | | | MANUFACTURER | | | |
FK Column | | | ID_NUMBER | | | |
Datatype | NUM | VARCHAR2 | VARCHAR2 | NUM | HUM | DATE |
Length | 9 | 25 | 26 | 9 | 8, 2 | |
要删除1997年7月25目之后的任何一个指定的库存记录(即具有一个特定标识号码的库存记录),请问在如下的语句中使用哪个来完成此项操作
A.DELETE FROM
inventory
WHERE
order_date>’25-JUL-1997’
AND
id_number=&id_number;
B.DROP FROM
inventory
WHERE
order_date>TO_DATE(’25-JUL-97’)
AND
id_number=&id_number;
C.DELETE FROM
inventory
WHERE
order_date=>’25-JUL-97’
AND
id_number=’&id_number’;
D.DELETE FROM
inventory
WHERE
order_date>(’25-JUL-1997’)
OR
id_number=&id_number;
E.DELETE FROM
inventory
WHERE
order_date>TO_DATE(’July 25, 1997’, ’DD.MM.YYYY’)
AND
id_number=&id_number;