INSERT /*+ APPEND */ INTO BV_DRILLTH (PV_SSID,PV_CRDATE,PV_SEQ) SELECT '' ,' ' ,COUNT(*) FROM A WHERE BETWEEN '' AND '' ; COMMIT ; EXIT