insert into hr_channel (hc_id,hc_name,hc_desc,hc_basic)
select a.d_id,a.d_name,a.d_desc,'Y' from hr_dictionary a where a.d_senior='7'
insert into hr_channel (hc_id,hc_name,hc_desc,hc_basic)
select a.d_id,a.d_name,a.d_desc,'Y' from hr_dictionary a where a.d_senior='7'