View the Exhibit and examine the description of the ORDERS table.
Evaluate the following SQL statement:
SELECT order_id, customer_id
FROM orders
WHERE order_date > ‘June 30 2001’;
Which statement is true regarding the execution of this SQL statement?
A.
It would not execute because ‘June 30 2001’ in the WHERE condition is not enclosed within double quotation marks.
B.
It would execute and would return ORDER_ID and CUSTOMER_ID for all records having ORDER_DATE greater than ‘June 30 2001’.
C.
It would not execute because ‘June 30 2001’ in the WHERE condition cannot be converted implicitly and needs the use of the TO_DATE conversion function for proper execution.
D.
It would not execute because ‘June 30 2001’ in the WHERE condition cannot be converted implicitly and needs the use of the TO_CHAR conversion function for proper execution.
SELECT 1 FROM dual WHERE sysdate > ‘June 30 2001’;
SELECT 1 FROM dual WHERE sysdate > sysdate – 1;
SELECT 1 FROM dual WHERE sysdate > to_date(‘June 30 2001’, ‘Mon dd yyyy’);