Page Comparison

create materialized view BANNER_INSTRUCTORS ( ENROLLMENTSET_EID, SECTION_EID, PIDM, SIRASGN_ROWID, SSBSECT_ROWID )
REFRESH FORCE
NEXT sysdate + 1 
as
	select distinct 'http://ucdavis.edu/course/enrollmentset/'||sa.SIRASGN_CRN||'/'||sa.SIRASGN_TERM_CODE,
        'http://ucdavis.edu/course/section/'||sb.SSBSECT_SUBJ_CODE||'/'||sb.SSBSECT_CRSE_NUMB||'/'||sb.SSBSECT_SEQ_NUMB||'/'||sb.SSBSECT_TERM_CODE,
         sa.SIRASGN_PIDM, sa.ROWID, sb.ROWID
        from SIRASGN sa, SSBSECT sb
        where sa.SIRASGN_TERM_CODE > 200410
        and   sa.SIRASGN_TERM_CODE <> 999999
        and   sa.SIRASGN_TERM_CODE = sb.SSBSECT_TERM_CODE
        and   sa.SIRASGN_CRN = sb.SSBSECT_CRN;