View the Exhibit and examine the description of the ORDERS table. Which two WHERE
clause conditions demonstrate the correct usage of conversion functions? (Choose two.)
A.
WHERE TO_CHAR(order_date,’MON DD YYYY} = ‘JAN 20 2003’
B.
WHERE order_date > T0_CHAR(ADD_M0NTHS(SYSDATE,6),’M0N DD YYYY’)
C.
WHERE order_date > TO_DATE(‘JUL 10 2006’,’MON DD YYYY”)
D.
WHERE order_date IN (T0_DATE(‘0ct 21 2003’,’Mon DD YYYY’), T0_CHAR(‘N0V 21
2003′,’Mon DD YYYY’))
Explanation: