DELETE FROM NHS_DC2.OR_100 WHERE PV_USER = '606';
commit;
INSERT INTO NHS_DC2.OR_100 (PV_KEY,PV_USER,PV1)
SELECT LPAD(TO_CHAR(ROWNUM),20,0),TABLE_SELECT.* FROM (
SELECT '606',COUNT(*)
FROM
 NPSS.FL0617 T001
) TABLE_SELECT
;
commit;
EXIT;


