HW4 - 2.) SQL> 2 3 4 5 ORDER -21619 21617 21623 3.) SQL>...

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

View Full Document Right Arrow Icon
2.) SQL> select order_num, customer.customer_num, 2 customer_name 3 from customer, orders 4 where customer.customer_num=orders.customer_num 5 and order_date = '23-OCT-10'; ORDER CUS CUSTOMER_NAME ----- --- ----------------------------------- 21619 148 Al's Appliance and Sport 21617 608 Johnson's Department Store 21623 608 Johnson's Department Store 3.) SQL> edit Wrote file afiedt.buf 1 select orders.order_num, order_date, part_num, 2 num_ordered, quoted_price 3 from orders, order_line 4* where orders.order_num=order_line.order_num SQL> / ORDER ORDER_DAT PART NUM_ORDERED QUOTED_PRICE ----- --------- ---- ----------- ------------ 21608 20-OCT-10 AT94 11 21.95 21610 20-OCT-10 DR93 1 495 21610 20-OCT-10 DW11 1 399.99 21613 21-OCT-10 KL62 4 329.95 21614 21-OCT-10 KT03 2 595 21617 23-OCT-10 BV06 2 794.95 21617 23-OCT-10 CD52 4 150 21619 23-OCT-10 DR93 1 495 21623 23-OCT-10 KV29 2 1290 9 rows selected. 6.)
Background image of page 1

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

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

This note was uploaded on 12/03/2009 for the course INFORMATIO IS 158 taught by Professor Dr.moffitt during the Spring '09 term at CSU Fresno.

Page1 / 3

HW4 - 2.) SQL> 2 3 4 5 ORDER -21619 21617 21623 3.) SQL>...

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

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