Using the TAL Distributors Database from A Guide To SQL (9th Edition), Change th

Question

Using the TAL Distributors Database from A Guide To SQL (9th Edition), Change the size of the customers "Brooking's Direct" and "Kline's" to Large. Display the customer number, customer name and size for all customers. Remove the customer size column from the customer table and demonstrate that it is gone.

Schema:

?eject Browser ? ? c ?127.0.0.1:8080/apex/f?p-4500:1001:645686924296311-NO::: ORACLE Application Express welcome SYSTEM I Logout ? Home Application Bulder SQL Workshop - Hame S0L Workshop Object Browser Scherma LAL ' Help Tatles Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS DEPT HTMLDB PLAN REP Appication Lxpress 4.0 2.00.09 Wolapac TAL Uaer SYSTEM Language en Copynght &1330, 2010, Crade All rihts eserved

Explanation / Answer

Answer)

Assuming that the column names of customer table are: customer_number, customer_name, customer_size.

select customer_number, customer_name, customer_size from customer;

Remove the customer size column from the customer table:

ALTER TABLE customer
DROP COLUMN customer_size;

Describe the changed table:

desc customer;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.