What could be the reason the following INSERT statement?

View the Exhibit and examine the structure of the CUSTOMERS table.
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have
the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:
INSERT INTO new_customers (cust_id, cust_name, cust_city)
VALUES(SELECT cust_id,cust_first_name’ ‘cust_last_name,cust_city
FROM customers
WHERE cust_id > 23004);
The INSERT statement fails when executed. What could be the reason?

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

NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have
the same data types and size as the corresponding columns in the CUSTOMERS table.

Evaluate the following INSERT statement:
INSERT INTO new_customers (cust_id, cust_name, cust_city)
VALUES(SELECT cust_id,cust_first_name’ ‘cust_last_name,cust_city
FROM customers
WHERE cust_id > 23004);
The INSERT statement fails when executed.

What could be the reason?

A.
The VALUES clause cannot be used in an INSERT with a subquery.

B.
Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.

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

D.
The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.



Leave a Reply 5

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


kar

kar

Insert into new_customers (select ….) is correct statement
so values should not come here

user

user

Using sub-selects example:

INSERT INTO suppliers
(supplier_id, supplier_name)
SELECT account_no, name
FROM customers
WHERE city = ‘Newark’;

So no, you cannot have the VALUES clause in the above statement.

Hossam

Hossam

A.
The VALUES clause cannot be used in an INSERT with a subquery.

Hossam

Hossam

if you want to make insert in the table from sub query can you make it like
INSERT INTO new_customers (cust_id, cust_name, cust_city)
(SELECT cust_id,cust_first_name’ ‘cust_last_name,cust_city
FROM customers
WHERE cust_id > 23004);