
DROP TABLE ADDS;
CREATE TABLE ADDS
(  
   SEQ          number,
   LNAME        varchar2 (30),
   FNAME        varchar2 (30),
   STREET       varchar2 (30),
   STREET2      varchar2 (30),
   CITY_ST      varchar2 (30),
   ZIP          varchar2 (10),
   HPHONE       varchar2 (15),
   WPHONE       varchar2 (15),
   OPHONE       varchar2 (50),
   KIDS         varchar2 (30),
   EMAIL        varchar2 (50),
   LAST_MOD_BY  varchar2 (10),
   LAST_MOD_DT  date,
   COMMENTS     varchar2 (50)
 );
