HW9 - IS 158 HW #8 1.) a) SQL> create view...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
IS 158 HW #8 1.) a) SQL> create view major_customer as 2 select customer_num, customer_name, 3 balance, credit_limit, rep_num 4 from customer 5 where credit_limit <= 10000; View created. b) SQL> select customer_num, customer_name 2 from major_customer 3 where balance > 10000;
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
no rows selected c) SQL> select customer_num, customer_name 2 from customer 3 where credit_limit <= 10000 4 and balance > 10000; no rows selected 6.) a) SQL> create index part_index1 on order_line(part_num); Index created.
Background image of page 2
b) SQL> create index part_index2 on part(class); Index created. c) SQL> create index part_index3 on part(class, warehouse); Index created. d) SQL> create index part_index4 on part(class desc, warehouse); Index created. 8.)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
a) SQL> edit Wrote file afiedt.buf 1 select TABLE_NAME 2 from USER_TAB_COLUMNS 3* where COLUMN_NAME = 'CUSTOMER_NUM' SQL> / TABLE_NAME ------------------------------ CUSTOMER DEMO_CUSTOMER DEMO_ORDERS MAJOR_CUSTOMER ORDERS SALES12
Background image of page 4
TRIAL2 8 rows selected. b)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 11

HW9 - IS 158 HW #8 1.) a) SQL&gt; create view...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online