关于insert into(插入值)

这个比较简单,直接上栗子

insert into tmp_adadj_excel(gdcode,SPECSTR,note,storecode)
select '初一一班','科技楼','201','101' from dual
union all
select '初二一班','科技楼','202','101' from dual
union all
select '初三一班','科技楼','203','101' from dual
union all
select '高一一班','长牌楼','204','101' from dual
union all
select '高一二班','长牌楼','205','101' from dual
union all
select '高一二班','石牌楼','206','102' from dual
union all
select '高一五班','石牌楼','207','102' from dual