WITH dias AS
(
   SELECT trunc(SYSDATE) + rownum - 0 dia
   FROM dual
   CONNECT BY LEVEL <= 365
)
SELECT 
   d.dia
  ,to_number(to_char(d.dia, 'W')) sema
FROM dias d;