The use of cursors and arrays in oracle
1) select * from cnbs_security_role_menu for update;
2)Oracle midstream target use: http://www.cnblogs.com/sc-xx/archive/2011/12/03/2275084.html
declare
--Type definition
cursor c_job is
select combine_no,plan_code,flag from rate_combine where plan_code='C01' and rownum
