获取序列的:
declare
v_seqstr varchar2(1000);
cursor c_seq is
select sequence_name from user_sequences;
begin
dbms_output.enable('99999999999999999999');
for v_seq in c_seq loop
select aa.cv into v_seqstr
from (select rownum rn, cc.column_value cv from table(w_func_getobjectddl('SEQUENCE', v_seq.sequence_name)) cc) aa
where aa.rn = 5;
dbms_output.put_line(v_seqstr);
end loop;
end;