Query SQL:

SELECT B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.ACAD_CAREER, A.ACAD_PROG, A.ACAD_GROUP, A.SUBJECT, A.CATALOG_NBR, A.CLASS_SECTION, A.SESSION_CODE, A.DESCR, A.UNT_TAKEN, A.CRSE_GRADE_OFF, TO_CHAR(A.GRADE_DT,'YYYY-MM-DD'),A.INSTITUTION,A.STRM,A.CLASS_NBR 
 FROM PS_CLASS_TBL_SE_VW A, PS_CU_BIO_VW B 
 WHERE ( A.INSTITUTION = :1 
 AND A.STRM = :2 
 AND A.GRADE_DT > TO_DATE(:3,'YYYY-MM-DD') 
 AND A.STDNT_ENRL_STATUS = 'E' 
 AND A.CRSE_GRADE_OFF IN (:4,:5,:6,:7,:8) 
 AND A.EMPLID = B.EMPLID ) 
 ORDER BY 1, 2, 3, 8, 9, 10

 



  • No labels