No Format |
---|
insert into ssrattr (ssrattr_term_code, ssrattr_crn, ssrattr_attr_code, ssrattr_activity_date) select ssbsect_term_code ssrattr_term_code, ssbsect_crn ssrattr_crn, 'INST' ssrattr_attr_code, sysdate ssrattr_activity_date from ssbsect where ssbsect_sapr_code is not null; commit; |