SQL> select * from zipcodes;

       ZIP CITY
---------- ------------------
     67226 Wichita


SQL> select * from employees;

       ENO ENAME                        ZIP        HDATE
---------- ---------------------------- ---------- ------------------
      1000 Jones                        67226      12-DEC-95


SQL> select * from parts;

       PNO PNAME                       QOH        PRICE      OLEVEL
---------- --------------------------- ---------- ---------- ----------
     10506 Land Before Time I          200        19.99      20




SQL> select * from customers;

       CNO  CNAME      STREET                ZIP        PHONE
----------- ---------- --------------------- ---------- -----
      1111  Charles    Main  St.             67226      316-636-5555



SQL> select * from orders;

       ONO        CNO        ENO RECEIVED           SHIPPED
---------- ---------- ---------- ------------------ ------------------
      1020       1111       1000 10-DEC-94          12-DEC-94

SQL> select * from odetails;

       ONO        PNO        QTY
---------- ---------- ----------
      1020      10506          1