Why would the INSERT statement fail?

View the Exhibit and examine the structure of the ORDERS table. NEW_ORDERS is a new table with the columns ORD_ID, ORD_DATE, CUST_ID, and ORD_TOTAL that have the same data types and size as the corresponding columns in the ORDERS table. Evaluate the following INSERT statement:
INSERT INTO new_orders (ord_id, ord_date, cust_id, ord_total) VALUES(SELECT order_id,order_date, customer_id,order_total FROM orders
WHERE order_date > ’31-dec-1999′); Why would the INSERT statement fail?

View the Exhibit and examine the structure of the ORDERS table.

NEW_ORDERS is a new table with the columns ORD_ID, ORD_DATE, CUST_ID, and ORD_TOTAL that have the same data types and size as the corresponding columns in the ORDERS table. Evaluate the following INSERT statement:

INSERT INTO new_orders (ord_id, ord_date, cust_id, ord_total) VALUES(SELECT order_id,order_date, customer_id,order_total FROM orders
WHERE order_date > ’31-dec-1999′);

Why would the INSERT statement fail?

A.
because column names in NEW_ORDERS and ORDERS tables do not match

B.
because the VALUES clause cannot be used in an INSERT with a subquery

C.
because the WHERE clause cannot be used in a subquery embedded in an INSERT statement

D.
because the total number of columns in the NEW_ORDERS table does not match the total number of columns in the ORDERS table



Leave a Reply 0

Your email address will not be published. Required fields are marked *