SQL> !ls

SQL> @tables

TABLE_NAME                                                                      
------------------------------                                                  
SALE                                                                            
CUSTOMER                                                                        
SALEPERSON                                                                      
DEALERSHIP                                                                      
DISTRIBUTOR                                                                     
ORDER_SHIPMENT                                                                  
TRADE_IN_VEHICLE                                                                
SALE_FINANCING                                                                  
SALE_VEHICLE                                                                    
FINANCING_PLAN                                                                  
VEHICLES                                                                        

TABLE_NAME                                                                      
------------------------------                                                  
TIME                                                                            
SALE_FACTS                                                                      
TEST                                                                            

14 rows selected.

SQL> desc sale
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SALE_ID                                            NUMBER(38)
 GROSS_SALE_PRICE                                   NUMBER(38)
 VIN                                                VARCHAR2(17)
 VEHICLE_STATUS                                     VARCHAR2(45)
 SALE_DATE                                          DATE
 MILEAGE                                            NUMBER(38)
 CUST_ID                                            NUMBER(38)
 SALESPERSON_ID                                     NUMBER(38)

SQL> desc customer
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CUST_ID                                            NUMBER(38)
 LAST                                               VARCHAR2(45)
 FIRST                                              VARCHAR2(45)
 NAME                                               VARCHAR2(45)
 MI                                                 CHAR(1)
 ADDRESS                                            VARCHAR2(45)
 STREET                                             VARCHAR2(45)
 CITY                                               VARCHAR2(45)
 STATE                                              VARCHAR2(45)
 ZIP                                                NUMBER(38)

SQL> desc saleperson
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SALESPERSON_ID                                     NUMBER(38)
 TITLE                                              VARCHAR2(45)
 MI                                                 CHAR(1)
 NAME                                               VARCHAR2(45)
 FIRST                                              VARCHAR2(45)
 LAST                                               VARCHAR2(45)
 HIRE_DATE                                          DATE

SQL> desc DEALERSHIP
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEALER_ID                                          NUMBER(38)
 OPENDATE                                           DATE
 PHONE                                              NUMBER(38)
 MANAGER                                            VARCHAR2(45)
 SQ_FT                                              NUMBER(38)
 LOCATION                                           VARCHAR2(45)
 REGION                                             VARCHAR2(45)

SQL> desc distributor
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DIST_ID                                            NUMBER(38)
 PHONE                                              NUMBER(38)
 CITY                                               VARCHAR2(45)
 STREET                                             VARCHAR2(45)
 ADDRESS                                            VARCHAR2(45)
 ZIP                                                NUMBER(38)
 STATE                                              VARCHAR2(45)
 POC                                                VARCHAR2(45)

SQL> desc ORDER_SHIPMENT
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEALER_ID                                          NUMBER(38)
 DIST_ID                                            NUMBER(38)
 OS_ID                                              NUMBER(38)
 SHIP_DATE                                          DATE

SQL> desc TRADE_IN_VEHICLE
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SALE_ID                                            NUMBER(38)
 TRADE_IN_AMOUNT                                    FLOAT(126)
 VIN                                                VARCHAR2(17)
 TRADE_ID                                           NUMBER(38)

SQL> desc SALE_FINANCING
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SALE_ID                                            NUMBER(38)
 PLAN_ID                                            NUMBER(38)
 LOAN_TERM                                          NUMBER(38)
 DOWN_PAY                                           NUMBER(38)

SQL> desc SALE_VEHICLE
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 VIN                                                VARCHAR2(17)
 TYPE                                               VARCHAR2(45)
 OS_ID                                              NUMBER(38)
 MODEL                                              VARCHAR2(45)
 MAKE                                               VARCHAR2(45)
 WHEREFROM                                          VARCHAR2(45)
 WHOLESALE_COST                                     FLOAT(126)
 TRADE_ID                                           NUMBER(38)

SQL> desc FINANCING_PLAN
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PLAN_ID                                            NUMBER(38)
 MIN_DOWN                                           NUMBER(38)
 MAX_LOAN_AMT                                       NUMBER(38)
 INSTITUTION                                        VARCHAR2(45)
 PERCENTAGE                                         NUMBER(10,2)
 LOAN_TYPE                                          VARCHAR2(45)
 MAX_TERM                                           NUMBER(38)

SQL> desc VEHICLES
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 VEHICLE_CODE                                       NUMBER(38)
 DESCRIPTION                                        VARCHAR2(120)

SQL> desc TIME
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SALE_DAY                                           DATE
 DAY_TYPE                                           VARCHAR2(20)

SQL> desc SALE_FACTS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SALE_DAY                                           DATE
 VEHICLE_CODE                                       NUMBER(38)
 DEALER_ID                                          NUMBER(38)
 PLAN_ID                                            NUMBER(38)

SQL> spool off