declare cursor my_cursors is select distinct c_fun_code from t_s_fun_rights where rownum < 3680; begin for my_cursor in my_cursors loop insert into t_s_fun_rights values(my_cursor.c_fun_code,'SealRelaInfo',''); end loop; end; 原文链接：https://www.f2er.com/oracle/207365.html