select to_date(to_char(dt.dt, 'YYYYMMDD'), 'YYYYMMDD')                         days
               , dense_rank() over(order by trunc(((dt.dt - to_date(:sStdt, 'YYYYMMDD')))/7) ) as rk
               from
               (select to_date(:sStdt,'YYYYMMDD')+(rownum-1)  dt
                  from dual
                connect by level <=53
                ) DT
               WHERE DT.DT Between TO_DATE(:sStdt, 'YYYYMMDD')
                               AND TO_DATE(:sEndt, 'YYYYMMDD')

Query는 위와 같구요..

그런데.... pc파일에서 이게 안먹히거든요...

dense_rank()  이함수를 사용할수 없는건가요?