ECET 450 WEEK 5

Name                                                  Null?    Type
—————————————————– ——– ————————————
CUST_ID                                               NOT NULL CHAR(4)
CUST_NAME                                                      VARCHAR2(30)
CUST_STREET                                                    VARCHAR2(20)
CUST_CITY                                                      VARCHAR2(20)
CUST_STATE                                                     CHAR(2)
CUST_ZIP                                                       CHAR(5)
CUST_BALANCE                                                   NUMBER(8,2)
CUST_LIMIT                                                     NUMBER(8,2)
REP_ID                                                         CHAR(3)

SQL> DESCRIBE REP;
 Name                                                  Null?    Type
 —————————————————– ——– ————————————
 REP_ID                                                NOT NULL CHAR(3)
 REP_LNAME                                                      VARCHAR2(20)
 REP_FNAME                                                      VARCHAR2(15)
 REP_STREET                                                     VARCHAR2(20)
 REP_CITY                                                       VARCHAR2(15)
 REP_STATE                                                      CHAR(2)
 REP_ZIP                                                        CHAR(5)
 REP_COMM                                                       NUMBER(7,2)
 REP_RATE                                                       NUMBER(3,2)