用前面创建的函数获取对象

获取序列的:
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;
请使用浏览器的分享功能分享到微信等