CREATE TABLE ECC_MASTER
(
  PARTY_TYPE      CHAR(1 BYTE)                  NOT NULL,
  PARTY_CODE      CHAR(5 BYTE)                  NOT NULL,
  ECC_NO          VARCHAR2(25 BYTE)             NOT NULL,
  RANGE_DIVISION  VARCHAR2(30 BYTE),
  EMP_NO          NUMBER(4)                     NOT NULL,
  LAST_UPD        DATE
)

Insert into ECC_MASTER
   (PARTY_TYPE, PARTY_CODE, ECC_NO, RANGE_DIVISION, EMP_NO, 
    LAST_UPD)
 Values
   ('V', 'VEB03', '020104536D', 'Range IV, Mumbai', 544, 
    TO_DATE('03/22/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into ECC_MASTER
   (PARTY_TYPE, PARTY_CODE, ECC_NO, RANGE_DIVISION, EMP_NO, 
    LAST_UPD)
 Values
   ('V', 'DED01', '0907040913', 'Electronics City/Div.III', 544, 
    TO_DATE('03/22/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into ECC_MASTER
   (PARTY_TYPE, PARTY_CODE, ECC_NO, RANGE_DIVISION, EMP_NO, 
    LAST_UPD)
 Values
   ('V', 'PED01', '2811034184', 'R-III/Div IV Noida', 544, 
    TO_DATE('03/22/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into ECC_MASTER
   (PARTY_TYPE, PARTY_CODE, ECC_NO, RANGE_DIVISION, EMP_NO, 
    LAST_UPD)
 Values
   ('V', 'KEU01', '1406051129', 'R-II/Div.Sec.11,UDR', 544, 
    TO_DATE('03/22/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into ECC_MASTER
   (PARTY_TYPE, PARTY_CODE, ECC_NO, RANGE_DIVISION, EMP_NO, 
    LAST_UPD)
 Values
   ('V', 'EDC01', '1902020749', 'R-III, Chandigarh', 544, 
    TO_DATE('03/22/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));