INSERT INTO PS_AF_PRWK_CNT_T(PROCESS_INSTANCE
, AF_STORE_NUM
,EMPLID
,WEEK_END_DT
,DAYOFWEEK
,COUNTER ) WITH n(PROCESS_INSTANCE
,AF_STORE_NUM
,EMPLID
,WEEK_END_DT
,DAYOFWEEK) AS (
SELECT PROCESS_INSTANCE,AF_STORE_NUM
,EMPLID
,WEEK_END_DT
,DAYOFWEEK
FROM PS_AF_PRWK_SCH_T WHERE EMPLID <> 'UNFILL'
UNION ALL
SELECT PROCESS_INSTANCE
,nplus1.AF_STORE_NUM
,nplus1.EMPLID
,nplus1.WEEK_END_DT
,nplus1.DAYOFWEEK
FROM PS_AF_PRWK_SCH_T nplus1
,n
WHERE n.DAYOFWEEK = nplus1.DAYOFWEEK-1
AND n.EMPLID=nplus1.EMPLID
AND n.AF_STORE_NUM=nplus1.AF_STORE_NUM
AND n.WEEK_END_DT=nplus1.WEEK_END_DT )
SELECT PROCESS_INSTANCE
,AF_STORE_NUM
,EMPLID
,WEEK_END_DT
,DAYOFWEEK
, COUNT(*)
FROM n
WHERE DAYOFWEEK=7
GROUP BY AF_STORE_NUM ,EMPLID,WEEK_END_DT,DAYOFWEEK

You can ask on Oracle forum.
Oracle - dBforums

Convert the common table expression into a subselect.

The common table expression "n" is a recursive CTE.
So, it might be converted to Oracle by using CONNECT BY syntax.