create table TTIMES
(
  YEAR                      VARCHAR2( 4 ) not null,
  YEAR_LONG_DESCRIPTION     VARCHAR2( 20 ) not null,
  YEAR_SHORT_DESCRIPTION    VARCHAR2( 20 ) not null,
  YEAR_END_DATE             DATE not null,
  YEAR_TIME_SPAN            NUMBER not null,
  QUARTER                   VARCHAR2( 6 ) not null,
  QUARTER_LONG_DESCRIPTION  VARCHAR2( 20 ) not null,
  QUARTER_SHORT_DESCRIPTION VARCHAR2( 20 ) not null,
  QUARTER_END_DATE          DATE not null,
  QUARTER_TIME_SPAN         NUMBER not null,
  MONTH                     VARCHAR2( 6 ) not null,
  MONTH_LONG_DESCRIPTION    VARCHAR2( 20 ) not null,
  MONTH_SHORT_DESCRIPTION   VARCHAR2( 20 ) not null,
  MONTH_END_DATE            DATE not null,
  MONTH_TIME_SPAN           NUMBER not null,
  DAY                       DATE not null,
  DAY_LONG_DESCRIPTION      VARCHAR2( 20 ) not null,
  DAY_SHORT_DESCRIPTION     VARCHAR2( 20 ) not null,
  DAY_END_DATE              DATE not null,
  DAY_TIME_SPAN             NUMBER not null
)
;

insert into TTIMES
select
  TO_CHAR(CD,'YYYY'),
  TO_CHAR(CD,'YYYY'),
  TO_CHAR(CD,'YYYY'),
  TO_DATE(TO_CHAR(CD,'YYYY')||'1231','YYYYMMDD'),  
  TO_DATE(TO_CHAR(CD,'YYYY')||'1231','YYYYMMDD')-trunc(CD,'Y')+ 1 ,  
  TO_CHAR(CD,'YYYYQ'),
  TO_CHAR(CD,'YYYYQ'),
  TO_CHAR(CD,'YYYYQ'),
  ADD_MONTHS(LAST_DAY(CD), 3 ),
  ADD_MONTHS(LAST_DAY(CD), 3 )-trunc(CD,'Q')+ 1 ,
  TO_CHAR(CD,'YYYYMM'),
  TO_CHAR(CD,'YYYYMM'),
  TO_CHAR(CD,'YYYYMM'),
  LAST_DAY(CD),
  LAST_DAY(CD)-trunc(CD,'MM')+ 1 ,
  CD,
  TO_CHAR(CD,'DD.MM.YYYY'),
  TO_CHAR(CD,'DD.MM.YYYY'),
  CD,
   1   
from 
 (select TO_DATE(&SD,'DD.MM.YYYY')+rownum- 1  CD from all_objects where rownum< 5000 ) d
where d.cd<= TO_DATE(&ED,'DD.MM.YYYY');