看下这倒OCP的题，我觉得很不对

royzs

View the Exhibit to examine the description for the SALES table

Which views can have all DML operations performed on it? (Choose all that apply.)

A.   CREATE VIEW v3

AS SELECT * FROM SALES

WHERE cust_id = 2034

WITH CHECK OPTION;

B.   CREATE VIEW vl

AS SELECT * FROM SALES

WHERE time_id <= SYSDATE - 2*365

WITH CHECK OPTION;

C.   CREATE VIEW v2

AS SELECT prod_id, cust_id, time_id FROM SALES

WHERE time id <= SYSDATE -2*365

WITH CHECK OPTION;

D. CREATE VIEW v4

AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALES

WHERE time id <= SYSDATE -2*365

GROUP BY prod_id, cust_id

WITH CHECK OPTION;

Answer: A, B

答案居然是A,B怎么可能呢，B选项明显不对啊，那time_id是日期类型怎么能比较大小呢，必须先to_number才行的啊，晕了

royzs

难道是末日的缘故吗，帖子都没人回复了

kycbt

这是个比较低级的问题,时间也可以加减运算，比较大小.

wlmouse

时间当然可以比较加减了。sysdate-1就是前一天。