Advertisement
ma39isy

Untitled

Mar 14th, 2024
1,196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     A.*,
  3.     TO_CHAR(A.BIRTHDATESTUDENT, 'DD/MM/YYYY') AS BIRTHDATE,
  4.     TO_CHAR(A.YUDISIUMDATE, 'DD/MM/YYYY') AS YUDISIUMDATE
  5. FROM
  6.     (
  7.     SELECT
  8.         *
  9.     FROM
  10.         MASTERDATA.STUDENT S
  11.     LEFT JOIN MASTERDATA.ADDITIONALSTUDENTDATA
  12.             USING(STUDENTID)
  13.     LEFT JOIN MASTERDATA.STUDYPROGRAM SP ON
  14.         (DECODE(S.CLASSIFICATIONID, '64', '64', S.STUDYPROGRAMID)= SP.STUDYPROGRAMID)
  15.     LEFT JOIN MASTERDATA.FACULTIES
  16.             USING(FACULTYID)
  17.     JOIN GRADUATION_PARTICIPANTS
  18.             USING (STUDENTID)
  19.     WHERE
  20.         STUDENTID = '1501204238') A
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement