1 2 3 4 5 6 7 8 9 10 11 12 13 14
| SELECT
case when mod(rownum-1,12)+1 <10 then
trunc((rownum-1)/12)+ to_number(to_char(date '2007-12-01','YYYY'))||0||cast(mod(rownum-1,12)+1 as varchar(2))
else
trunc((rownum-1)/12)+ to_number(to_char(date '2007-12-01','YYYY'))||cast(mod(rownum-1,12)+1 as varchar(2))
end period_COD,
'P'||cast(mod(rownum-1,12)+1 as varchar(2)) as period_lib,
mod(rownum-1,12)+1 as PERIOD_NUM,
trunc((rownum-1)/12)+ to_number(to_char(date '2007-12-01','YYYY')) as fiscal_year,
date '2007-12-01' + trunc((rownum+1)*13/3)*7 -56 deb_period,
date '2007-12-01' + trunc((rownum+2)*13/3)*7 -57 end_period,
CURRENT_DATE as date_cre,CURRENT_DATE as date_MAJ
FROM dual
connect BY level<43 |
Partager