Hi, with sequences as ( select sequence_name from user_sequences ) select DBMS_METADATA.GET_DDL('SEQUENCE',sequence_name) from sequences; Phil On Fri, Oct 5, 2012 at 2:42 PM, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>wrote: > Hi Friends, > I have the following situation: I want to retrieve all sequences , or all > synonyms without specify each sequence name or synonym name using > DBMS_METADATA.get_ddl. > > This does not work. I need to specify the sequence name. > > > -- //www.freelists.org/webpage/oracle-l