SQL & PL/SQL

Hi ,

I used to work with TERADATA, and now i'm migrating an application to ORACLE

I got a problem whit the calendar :

i used this script to creata calendar on TERADATA :

REPLACE VIEW DWH.CALENDAR_FR AS
LOCKING SYS_CALENDAR.CALBASICS FOR ACCESS
(
SELECT
CALENDAR_DATE AS CALENDAR_DATE,
(DAY_OF_CALENDAR + 6) mod 7 + 1 AS DAY_OF_WEEK,
DAY_OF_MONTH AS DAY_OF_MONTH,
DAY_OF_YEAR AS DAY_OF_YEAR,
DAY_OF_CALENDAR AS DAY_OF_CALENDAR,
(DAY_OF_MONTH - 1) / 7 + 1 AS WEEKDAY_OF_MONTH,
(DAY_OF_MONTH - (DAY_OF_CALENDAR + 6 ) mod 7 + 6) / 7 + 1 - ((1 - (DAY_OF_CALENDAR - DAY_OF_MONTH + 1 + 6) mod 7 + 6) / 7) AS WEEK_OF_MONTH,
(DAY_OF_YEAR - (DAY_OF_CALENDAR + 6 ) mod 7 + 6) / 7 + 1 - ((1 - (DAY_OF_CALENDAR - DAY_OF_YEAR + 1 + 6 ) mod 7 + 6) / 7) AS WEEK_OF_YEAR,
(DAY_OF_CALENDAR - (DAY_OF_CALENDAR + 6 ) mod 7 + 6) / 7 AS WEEK_OF_CALENDAR,
(MONTH_OF_YEAR - 1) mod 3 + 1 AS MONTH_OF_QUARTER,
MONTH_OF_YEAR AS MONTH_OF_YEAR,
MONTH_OF_YEAR + 12 * YEAR_OF_CALENDAR AS MONTH_OF_CALENDAR,
(MONTH_OF_YEAR + 2) / 3 AS QUARTER_OF_YEAR,
(MONTH_OF_YEAR + 2) / 3 + 4 * YEAR_OF_CALENDAR AS QUARTER_OF_CALENDAR,
YEAR_OF_CALENDAR + 1900 AS YEAR_OF_CALENDAR
FROM
SYS_CALENDAR.CALBASICS
);

i want to do the same thing with ORACLE but i'm stucking whith ''SYS_CALENDAR.CALBASICS'' there is no equivalent on oracle so i can't get the : DAY_OF_CALENDAR
DAY_OF_MONTH
DAY_OF_YEAR


thanks in advance