How to get all names of specific object - DBMS_METADATA

  • From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 5 Oct 2012 10:42:35 -0300

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.

SELECT DBMS_METADATA.GET_DDL('SEQUENCE','*') FROM DUAL;


I would like to retrieve all sequences and don´t do it:

   FOR l in (SELECT sequence_name objname
               FROM user_sequences)
    LOOP
  vobjname := l.objname;
      SELECT DBMS_METADATA.GET_DDL('SEQUENCE',vobjname) INTO vddl FROM DUAL;
    END LOOP;


Any experience with this command ?

Regards
Eriovaldo

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2012