Course Detail
SELECT A.*, decode(PRIM_INSTR_NAME, 'NAME NOT FOUND FOR PIDM: ', 'Staff', PRIM_INSTR_NAME) INST_NAME FROM CVTC_CRSE_SECT_NEW A, SSRMEET WHERE TERM_CODE_KEY like '%' AND SSRMEET_TERM_CODE like '%' AND SSRMEET_CRN like CRN_KEY AND SSRMEET_ROOM_CODE = '' AND SSRMEET_BLDG_CODE = '' AND ('' between SSRMEET_BEGIN_TIME and SSRMEET_END_TIME) ORDER BY PTRM_START_DATE;
Course Title
(Click for Description) |
Course Number |
CRN |
Start Date
End Date |
Days |
Time |
#
Weeks |
Credit |
Building/
Room |
Instructor |
SELECT slbevnt_crn, slbevnt_desc, e1.* FROM CVTC_CRSE_SECT_NEW, slbevnt, SSRMEET e1 where e1.ssrmeet_term_code = 'EVENT' and e1.ssrmeet_room_code = '' and e1.ssrmeet_bldg_code = '' AND (sysdate + -2) between SSRMEET_START_DATE and (SSRMEET_END_DATE+1) and slbevnt_crn = e1.ssrmeet_crn and term_code_key = 'EVENT' and crn_key = e1.ssrmeet_crn;
|
Toll-free: 1-800-547-CVTC