INSERT INTO CONSULT_SCHEDULE

  (ORG_ID,

   DEPENT_ID,

   DEPENT_NAME,

   DOCTOR_ID,

   DOCTOR_NAME,

   DOCTOR_PHONE,

   SCHEDULE_DATE,

   WEEK_TXT,

   WB_TYPE,

   CLOSE_TZ,

   REPLACE_TZ)

  (SELECT T2.ORG_ID,

          T2.DEPENT_ID,

          T2.DEPENT_NAME,

          T2.DOCTOR_ID,

          T2.DOCTOR_NAME,

          T2.DOCTOR_PHONE,

          (T2.SCHEDULE_DATE + 7) SCHEDULE_DATE,

          T2.WEEK_TXT,

          T2.WB_TYPE,

          T2.CLOSE_TZ,

          T2.REPLACE_TZ

     FROM CONSULT_SCHEDULE T2

    WHERE T2.SCHEDULE_DATE BETWEEN TO_DATE('2017-12-18', 'yyyy-MM-dd') AND

          TO_DATE('2017-12-24', 'yyyy-MM-dd'));