SELECT
    A.*,
    TO_CHAR(A.BIRTHDATESTUDENT, 'DD/MM/YYYY') AS BIRTHDATE,
    TO_CHAR(A.YUDISIUMDATE, 'DD/MM/YYYY') AS YUDISIUMDATE
FROM
    (
    SELECT
        *
    FROM
        MASTERDATA.STUDENT S
    LEFT JOIN MASTERDATA.ADDITIONALSTUDENTDATA
            USING(STUDENTID)
    LEFT JOIN MASTERDATA.STUDYPROGRAM SP ON
        (DECODE(S.CLASSIFICATIONID, '64', '64', S.STUDYPROGRAMID)= SP.STUDYPROGRAMID)
    LEFT JOIN MASTERDATA.FACULTIES
            USING(FACULTYID)
    JOIN GRADUATION_PARTICIPANTS
            USING (STUDENTID)
    WHERE
        STUDENTID = '1102190131') A