如:在当前用户下创建两个sequence,seq_student和seq_score
思路:使用v_array存放需要创建的sequence的名称集合
--批量创建sequence
declare
type v_array is varray(2) of varchar2(100);
v_index number;
v_arr v_array:=v_array('student',
'score');
v_sql varchar2(2000);
begin
for i in 1..v_arr.count loop
v_sql:='create sequence seq_'||v_arr(i)
||' minvalue 1 start with 1 increment by 1 cache 2';
--dbms_output.put_line(v_sql);
execute immediate v_sql;
end loop;
end;