Re: How to get all names of specific object - DBMS_METADATA

From: Phillip Jones <phil_at_phillip.im>
Date: Fri, 5 Oct 2012 14:54:46 +0100
Message-ID: <CAOyzJufC1=+pPeRqQJjgN+Q_Sf2iZPR7Z=rS9n5gkRCtE+ZADQ_at_mail.gmail.com>

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_at_gmail.com>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.
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 05 2012 - 15:54:46 CEST