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;
Overview
Content Tools