各位好.请教一个问题
我有表store,储存店铺号码;表download,储存门店资料下发
select storecode from store
---------------------------
storecode
1001
1002
1003
...

select * from download
----------------------

storecode date type reciver
2000 sysdate normal sysdba
2001 sysdate normal sysdba
2002 sysdate normal sysdba




现在想做一个function,能够将select storecode from store的结果,
匹配到insert into download values ('storecode',sysdate,'normal','sysdba')
也就是类似三个insert 语句,想到了循环,但是不知怎么写,求助
表达可能不清楚,在线等各位协助