Query SQL;
Panel |
---|
SELECT DISTINCT A.ACAD_GROUP, A.ACAD_ORG, A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.CLASS_SECTION, A.STRM, A.CLASS_STAT, A.INSTRUCTION_MODE, A.ROOM_CAP_REQUEST, A.ENRL_TOT, E.FACILITY_ID, TO_CHAR(CAST((E.MEETING_TIME_START) AS TIMESTAMP),'HH24.MI.SS.FF'), TO_CHAR(CAST((E.MEETING_TIME_END) AS TIMESTAMP),'HH24.MI.SS.FF'), decode ( E.MON, 'Y', 'Mo') || decode ( E.TUES, 'Y', 'Tu') || decode ( E.WED, 'Y', 'We') || decode ( E.THURS, 'Y', 'Th') || decode ( E.FRI, 'Y', 'Fr') || decode ( E.SAT, 'Y', 'Sa') || decode ( E.SUN, 'Y', 'Su'), B.LAST_NAME, B.FIRST_NAME, C.EMAIL_ADDR, TO_CHAR(SYSDATE,'YYYY-MM-DD'),A.CRSE_ID,A.CRSE_OFFER_NBR,A.SESSION_CODE FROM PS_CLASS_TBL A, PS_CLASS_MTG_PAT E, PS_CLASS_INSTR_VW5 B, PS_CU_BIO_VIEW C WHERE A.INSTITUTION = :1 AND A.STRM BETWEEN :2 AND :3 AND A.CRSE_ID = E.CRSE_ID (+) AND A.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR (+) AND A.STRM = E.STRM (+) AND A.SESSION_CODE = E.SESSION_CODE (+) AND A.CLASS_SECTION = E.CLASS_SECTION (+) AND E.CRSE_ID = B.CRSE_ID (+) AND E.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR (+) AND E.STRM = B.STRM (+) AND E.SESSION_CODE = B.SESSION_CODE (+) AND E.CLASS_SECTION = B.CLASS_SECTION (+) AND E.CLASS_MTG_NBR = B.CLASS_MTG_NBR (+) AND A.CATALOG_NBR LIKE '%H' AND B.EMPLID = C.EMPLID (+) ORDER BY 1, 2, 3, 4, 6 |