Guest User

Untitled

a guest
Apr 26th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.90 KB | None | 0 0
  1. SELECT DISTINCT s.sc_crs_number, p.sc_dept_code,
  2.        p.sc_crs_number, s.sc_dept_code,
  3.        Conflicting_course.mainFunction(p.sc_dept_code, p.sc_crs_number,
  4.                                        s.sc_dept_code, s.sc_crs_number,
  5.                                        p.sc_semester, std.std_grad_year,
  6.                        secp.sec_section, secs.sec_section)
  7. FROM student_course p, student_course s, section secs, section secp, student std
  8. WHERE p.sc_dept_code = 'CSIS' AND s.sc_dept_code != 'CSIS'
  9.       AND p.sc_semester = s.sc_semester
  10.       AND s.sc_std_id = p.sc_std_id
  11.       AND p.sc_crs_number >= 100 AND s.sc_crs_number >= 100
  12.       AND p.sc_semester = 'SP2012'
  13.       AND Conflicting_course.mainFunction(p.sc_dept_code, p.sc_crs_number,
  14.                      s.sc_dept_code, s.sc_crs_number, p.sc_semester, std.std_grad_year,
  15.                        secp.sec_section, secs.sec_section) >= 1
  16. ORDER BY s.sc_dept_code
Add Comment
Please, Sign In to add comment