Oracle ÅúÁ¿µ¼ÈëSequence

 select 'create sequence '||sequence_name||  
       ' minvalue '||min_value||  
       ' maxvalue '||max_value||  
       ' start with '||last_number||  
       ' increment by '||increment_by||  
       (case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'  //Õâ¸öÊÇʵʱµÄSequence
from user_sequences
select  d.text,d.name  from   user_source    d  where  type   ='PROCEDURE' ; //²éѯËùÓд洢¹ý³Ì
SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE, u.object_name)
  from USER_OBJECTS u
 where U.OBJECT_TYPE IN ('TABLE','INDEX','PROCEDURE','sequence');//µÃµ½Ò»¸öÓû§ÏµÄËùÓÐ±í£¬Ë÷Òý£¬´æ´¢¹ý³Ì,sequence .......µÄddl