SELECT *
FROM (
    SELECT
        WORKING_SCHEDULE_ID,
        NBR_HR,
        PH_MOBILITY,
        HP_MOBILITY,
        NBR_HR_AM,
        NBR_HR_PM,
        START_WORKING_TIME,
        STOP_WORKING_TIME,
        PAUSE_START_TIME,
        PAUSE_STOP_TIME,
        NBR_HR_FOR_ABSENCE,
        DAY_ID
    FROM OF_OWNER.WORKING_SCHEDULE_DAY
)
PIVOT (
    MAX(NBR_HR) AS NBR_HR,
    MAX(PH_MOBILITY) AS PH_MOBILITY,
    MAX(HP_MOBILITY) AS HP_MOBILITY,
    MAX(NBR_HR_AM) AS NBR_HR_AM,
    MAX(NBR_HR_PM) AS NBR_HR_PM,
    MAX(START_WORKING_TIME) AS START_WORKING_TIME,
    MAX(STOP_WORKING_TIME) AS STOP_WORKING_TIME,
    MAX(PAUSE_START_TIME) AS PAUSE_START_TIME,
    MAX(PAUSE_STOP_TIME) AS PAUSE_STOP_TIME,
    MAX(NBR_HR_FOR_ABSENCE) AS NBR_HR_FOR_ABSENCE
    FOR DAY_ID IN (1 AS MONDAY, 2 AS TUESDAY, 3 AS WEDNESDAY, 4 AS THURSDAY,
                   5 AS FRIDAY, 6 AS SATURDAY, 7 AS SUNDAY)
)
ORDER BY WORKING_SCHEDULE_ID;