assignment2

assignment2 - 1)SQL> select table_name from user_tables...

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

View Full Document Right Arrow Icon
Sheet1 1.)SQL> select table_name from user_tables TABLE_NAME -----------------------------CUSTOMERS AGENTS PRODUCTS ORDERS 2.)SQL> describe products Name Null? Type ----------------------------------------- -------- -------------------------PID PNAME CITY QUANTITY PRICE NOT NULL CHAR(3) VARCHAR2(13) VARCHAR2(20) NUMBER(10) FLOAT(63) 3.)SQL> select cname from customers CNAME ------------Tiptop Basics Allied ACME ACME 4.)SQL> Select ordno from orders ORDNO ---------1011 1012 1019 1017 1018 1023 1022 1025 1013 1026 1015 ORDNO ---------1014 1021 1016 1020 Page 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Sheet1 1024 16 rows selected. 5.)SQL> select pname from products PNAME ------------ comb brush razor pen pencil folder case 7 rows selected. 6.)SQL> select cname, city from customers CNAME CITY ------------- -------------------Tiptop Duluth Basics Dallas Allied Dallas ACME Duluth ACME Kyoto 7.)SQL> select pname, price from products PNAME PRICE ------------- ---------comb .5 brush .5 razor 1 pen 1 pencil 1 folder 2 case 1 7 rows selected. 8.)SQL> select cname from customers where city =
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2008 for the course CSIS 3310 taught by Professor Guimares during the Spring '08 term at Kennesaw.

Page1 / 6

assignment2 - 1)SQL> select table_name from user_tables...

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

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