Query
**********
set linesize 2000
set pages 5000
set space 0
set term off
set head off
set pagesize 0
set arraysize 1
set feedback off
set embedded on


spool c:\report.txt

SELECT 'Mail File'  ||','|| 
        'Count'     ||','|| 
       'Sales Dec 2011'  ||','||  
        'Sales Jan 2012' ||','|| 
       'Sales Feb 2012' ||','||       
        'Total Sales'   ||','|| 
       'Percent of Sale'
FROM DUAL
union all
SELECT to_char(TRUNC (m.added_date),'dd-Mon-yyyy') ||','||
       m.record_cnt ||','||
       nvl(b."Sales Dec 2011",0)  ||','|| 
       nvl(b."Sales Jan 2012",0) ||','||
      nvl(b."Sales Feb 2012",0)  ||','||       
       nvl(b."Total Sales",0)  ||','||
       nvl(b."sales_percent",0) 
FROM zam_co_extract_log m, 
(SELECT  tab1.extract_id,
         SUM (CASE WHEN tab1.applied_mon = 'DEC-2011' THEN cnt ELSE 0  END) "Sales Dec 2011",
         SUM (CASE WHEN tab1.applied_mon = 'JAN-2012' THEN cnt ELSE 0  END) "Sales Jan 2012",
         SUM (CASE WHEN tab1.applied_mon = 'FEB-2012' THEN cnt ELSE 0  END) "Sales Feb 2012",
         SUM (cnt) "Total Sales"  ,  
        round((SUM (cnt)/tab2.record_cnt)*100,2) "sales_percent"
    FROM (SELECT  extract_id, added_date, applied_mon, COUNT (1) cnt
              FROM (SELECT l.extract_id, TRUNC (l.added_date) added_date,
                     TO_CHAR (drr.applied_date, 'MON') || '-' || TO_CHAR (drr.applied_date, 'YYYY') applied_mon
                      FROM zam_co_extract_log l,
                           plc_sr_au_drrs_hist drr,
                           zam_sr_au_incentive_cust_hist inc
                     WHERE TRIM (UPPER (inc.addr1)) = TRIM (UPPER (drr.addr1))
                       AND l.extract_id = inc.extract_id
                       AND drr.applied_date > inc.added_date                                             
                       AND drr.reject_code IS NULL
                   )
          GROUP BY extract_id,added_date, applied_mon) tab1,
         (SELECT TRUNC (added_date) added_date, record_cnt,extract_id FROM zam_co_extract_log) tab2
   WHERE tab1.added_date = tab2.added_date
GROUP BY tab1.extract_id,tab2.record_cnt) b
where m.extract_id = b.extract_id(+)
union all
select 'Total Mailed'||','|| rec_cnt||','|| null||','|| null||','||null||','|| cnt||','|| round(cnt/(rec_cnt)*100,2)
from
(
SELECT count(1) cnt
                      FROM zam_co_extract_log l,
                           plc_sr_au_drrs_hist drr,
                           zam_sr_au_incentive_cust_hist inc
                     WHERE TRIM (UPPER (inc.addr1)) = TRIM (UPPER (drr.addr1))
                       AND l.extract_id = inc.extract_id
                       AND drr.applied_date > inc.added_date  
                       AND drr.reject_code IS NULL),         
(SELECT sum(record_cnt) rec_cnt FROM zam_co_extract_log)
/

spool off
set feedback on
quit  

create & insert scripts
*********************************

create table zam_co_extract_log
(extract_id number,added_date date,record_cnt number);

begin
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (2, TO_DATE('12/08/2011 08:02:38', 'MM/DD/YYYY HH24:MI:SS'), 144);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (21, TO_DATE('12/09/2011 09:13:25', 'MM/DD/YYYY HH24:MI:SS'), 896);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (42, TO_DATE('12/13/2011 03:26:36', 'MM/DD/YYYY HH24:MI:SS'), 2188);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (61, TO_DATE('12/15/2011 04:33:02', 'MM/DD/YYYY HH24:MI:SS'), 624);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (81, TO_DATE('12/21/2011 08:39:22', 'MM/DD/YYYY HH24:MI:SS'), 1200);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (102, TO_DATE('12/28/2011 07:09:30', 'MM/DD/YYYY HH24:MI:SS'), 1486);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (121, TO_DATE('01/04/2012 02:41:16', 'MM/DD/YYYY HH24:MI:SS'), 923);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (141, TO_DATE('01/11/2012 12:39:45', 'MM/DD/YYYY HH24:MI:SS'), 1076);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (161, TO_DATE('01/18/2012 04:25:44', 'MM/DD/YYYY HH24:MI:SS'), 1222);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (181, TO_DATE('01/25/2012 01:10:32', 'MM/DD/YYYY HH24:MI:SS'), 1667);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (201, TO_DATE('02/01/2012 01:43:54', 'MM/DD/YYYY HH24:MI:SS'), 1858);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (221, TO_DATE('02/08/2012 04:29:54', 'MM/DD/YYYY HH24:MI:SS'), 2038);
Insert into zam_CO_EXTRACT_LOG
   (EXTRACT_ID, ADDED_DATE, RECORD_CNT)
 Values
   (241, TO_DATE('02/15/2012 02:30:00', 'MM/DD/YYYY HH24:MI:SS'), 2527);
COMMIT;
end;

/


create table zam_sr_au_incentive_cust_hist
(extract_id number,addr1 varchar2(50), added_date date);

begin
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (2, '14824 SW 125TH CT', TO_DATE('12/09/2011 04:51:12', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (21, 'PO BOX 324', TO_DATE('12/09/2011 09:52:21', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (21, '3920 14TH AVE SE', TO_DATE('12/09/2011 09:52:21', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (21, '1555 CRAYTON RD', TO_DATE('12/09/2011 09:52:21', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (21, '306 N MAIN ST', TO_DATE('12/09/2011 09:52:21', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (21, '15501 BRUCE B DOWNS BLVD', TO_DATE('12/09/2011 09:52:21', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (42, 'PO BOX 712', TO_DATE('12/14/2011 04:55:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (42, '38 CAYUGA RD', TO_DATE('12/14/2011 04:55:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (42, '14824 SW 125TH CT', TO_DATE('12/14/2011 04:55:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (42, '815 W BOYNTON BEACH BLVD', TO_DATE('12/14/2011 04:55:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (42, '4722 SW 13TH CT', TO_DATE('12/14/2011 04:55:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (61, '9100 VANCE ST', TO_DATE('12/15/2011 04:34:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (61, '4641 POND RIDGE DR', TO_DATE('12/15/2011 04:34:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (61, '324 MAIN ST', TO_DATE('12/15/2011 04:34:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (61, '12780 SW 117TH ST', TO_DATE('12/15/2011 04:34:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (61, '332 MEADOWOOD LN', TO_DATE('12/15/2011 04:34:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (61, '807 W OAKLAND PARK BLVD', TO_DATE('12/15/2011 04:34:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, 'PO BOX 324', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, '1850 COTILLION DR', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, '500 TRINITY LN N', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, '411 WALNUT ST', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, '3410 GALT OCEAN DR', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, '1020 8TH AVE S', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, '4501 WOODWARD AVE', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (81, '3300 PORT ROYALE DR N', TO_DATE('12/21/2011 08:53:52', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (102, '2111 KEENAN AVE', TO_DATE('12/28/2011 07:10:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (102, 'PO BOX 694', TO_DATE('12/28/2011 07:10:06', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (121, '469 ENA RD', TO_DATE('01/04/2012 02:41:25', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (121, '4501 WOODWARD AVE', TO_DATE('01/04/2012 02:41:26', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (121, '21 CARDINAL AVE', TO_DATE('01/04/2012 02:41:27', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (161, '1232 N FAIRVIEW AVE', TO_DATE('01/18/2012 04:26:42', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (161, '13613 LAKES WAY', TO_DATE('01/18/2012 04:26:41', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (181, 'PO BOX 1233', TO_DATE('01/25/2012 01:34:08', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (181, 'PO BOX 5724', TO_DATE('01/25/2012 01:34:10', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (181, 'PO BOX 161', TO_DATE('01/25/2012 01:34:10', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (201, '212 LOCH LOW DR', TO_DATE('02/01/2012 01:56:05', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (221, '1580 NW 128TH DR', TO_DATE('02/08/2012 04:30:08', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (221, '251 10TH ST NW', TO_DATE('02/08/2012 04:30:08', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (221, 'PO BOX 31', TO_DATE('02/08/2012 04:30:09', 'MM/DD/YYYY HH24:MI:SS'));
Insert into zam_SR_AU_INCENTIVE_CUST_HIST
   (EXTRACT_ID, ADDR1, ADDED_DATE)
 Values
   (221, '11839 WHITEHILL ST', TO_DATE('02/08/2012 04:30:10', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;
end;

/


create table  plc_sr_au_drrs_hist (applied_date date,addr1 varchar2(50), 
                                  reject_code varchar2(10), new_used_ind varchar2(1));

begin
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('12/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4722 SW 13th Ct', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('12/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PO Box 712', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('12/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '815 W Boynton Beach Blvd', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '306 N Main St', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '15501 Bruce B Downs Blvd', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '324 Main St', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1555 Crayton Rd', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '469 Ena Rd', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '500 Trinity Ln N', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '332 Meadowood Ln', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '2111 Keenan Ave', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '3300 Port Royale Dr N', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PO Box 694', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '411 Walnut St', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '324 Main St', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '12780 SW 117th St', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '38 Cayuga Rd', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1850 Cotillion Dr', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '14824  125TH CT', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PO Box 161', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PO Box 1233', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '13613 Lakes Way', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '807 W Oakland Park Blvd', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PO Box 5724', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PO Box 31', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '21 Cardinal Ave', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4501 Woodward Ave', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PO Box 324', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '3300 Port Royale Dr N', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1580 NW 128th Dr', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4641 Pond Ridge Dr', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4641 Pond Ridge Dr', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1020 8th Ave S', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1232 N Fairview Ave', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '251 10th St NW', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '212 Loch Low Dr', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '3410 Galt Ocean Dr', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '3920 14TH AVE ', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '9100 Vance St', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '9100 Vance St', 'W');
Insert into plc_SR_AU_drrS_HIST
   (APPLIED_DATE, ADDR1, NEW_USED_IND)
 Values
   (TO_DATE('02/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '11839 Whitehill St', 'W');
COMMIT;
end;

/