【单项选择题】
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:<br /> CUST_ID NUMBER(4) NOT NULL<br /> CUST_NAME VARCHAR2(100) NOT NULL<br /> CUST_ADDRESS VARCHAR2(150)<br /> CUST_PHONE VARCHAR2(20)<br /> Which SELECT statement accomplishes this task?（）<p> You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:<br /> CUST_ID NUMBER(4) NOT NULL<br /> CUST_NAME VARCHAR2(100) NOT NULL<br /> CUST_ADDRESS VARCHAR2(150)<br /> CUST_PHONE VARCHAR2(20)<br /> Which SELECT statement accomplishes this task?（）</p>
A、A. SELECT* FROM customers;
B、B. SELECT name, address FROM customers;
C、C. SELECT id, name, address, phone FROM customers;
D、D. SELECT cust_name, cust_address FROM customers;
E、E. SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
查看正确答案
