CREATE TABLE SURVIVOR_SHIP
(
  SEQ_NUM      NUMBER,
  SOURCE1      VARCHAR2(200 BYTE),
  EMAILID      VARCHAR2(100 BYTE),
  EMAIL_FLAG   VARCHAR2(2 BYTE),
  ACTIVE_FLAG  VARCHAR2(10 BYTE),
  UPDATE_DATE  DATE,
  WORK_PHONE   VARCHAR2(100 BYTE)
);

begin 
Insert into SURVIVOR_SHIP
   (SEQ_NUM, SOURCE1, EMAILID, ACTIVE_FLAG, UPDATE_DATE, 
    WORK_PHONE)
 Values
   (1, 'GCOM', 'GCOM.COM', 'Y', TO_DATE('12/11/2017 04:14:29', 'MM/DD/YYYY HH24:MI:SS'), 
    '+11111GCOM');
Insert into SURVIVOR_SHIP
   (SEQ_NUM, SOURCE1, EMAILID, ACTIVE_FLAG, UPDATE_DATE, 
    WORK_PHONE)
 Values
   (2, 'ELOQUA', 'ELOQUA.COM', 'Y', TO_DATE('12/10/2017 04:14:29', 'MM/DD/YYYY HH24:MI:SS'), 
    '+11111ELOQUA');
Insert into SURVIVOR_SHIP
   (SEQ_NUM, SOURCE1, EMAILID, ACTIVE_FLAG, UPDATE_DATE, 
    WORK_PHONE)
 Values
   (3, 'PWS', 'PWS.COM', 'Y', TO_DATE('12/09/2017 04:14:29', 'MM/DD/YYYY HH24:MI:SS'), 
    '+11111PWS');
Insert into SURVIVOR_SHIP
   (SEQ_NUM, SOURCE1, EMAILID, ACTIVE_FLAG, UPDATE_DATE, 
    WORK_PHONE)
 Values
   (4, 'CRM', 'CRM.COM', 'Y', TO_DATE('12/08/2017 04:14:29', 'MM/DD/YYYY HH24:MI:SS'), 
    '+11111CRM');
COMMIT;
end;