Question: Using the TAL Distributors Database from A Guide To SQL (9th Edition), Add a column to the customer table to rank the relative size of

Using the TAL Distributors Database from A Guide To SQL (9th Edition), Add a column to the customer table to rank the relative size of the customer, Small, Medium or Large. Initially set all the customers to Medium. Create an index on the new size column. Display the customer number, customer name and size for all customers.

Schema:

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

?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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!