OraFAQ Forum: SQL & PL/SQL » Dependent Objects recursively

Home » SQL & PL/SQL » SQL & PL/SQL » Dependent Objects recursively (Oracle 11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dependent Objects recursively [message #663308]

Mon, 29 May 2017 12:05

pointers
Messages: 451
Registered: May 2008

Senior Member

Hi,

I am trying to pull DDL's of all the components of a given object using DBA_DEPENDENCIES and then DBMS_METADATA.GET_DDL

But is there a built in method to pull all the dependent objects recursively.

Thank you in advance.

Regards,
Pointers

Report message to a moderator

Re: Dependent Objects recursively [message #663309 is a reply to message #663308]

Mon, 29 May 2017 12:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

some, many, most Professional IT group keep all application code, including DDL, in source code repository; such as subversion.

FUNCTION GET_DEPENDENT_DDL RETURNS CLOB

Report message to a moderator