Re: Extracting SQL from DBA_SOURCE
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: "oraracdba" <oraracdba@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 12 Oct 2010 07:10:53 -0400
Ok if you are looking for dependencies then look in the dependencies view
otherwise guess its a manual process, good luck
Joe
Sent from the crackberry, so please excuse the typos and terseness.
----- Original Message -----
From: "Scott Heisey" [oraracdba@xxxxxxxxx]
Sent: 10/11/2010 07:39 PM MST
To: Joseph Testa; "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
Cc: "'Jared Still'" <jkstill@xxxxxxxxx>
Subject: RE: Extracting SQL from DBA_SOURCE
I don’t want the meta data SQL, I actually want the SQL inside the package.
I want to suck the SQL statements out the package and throw away all the
PL/SQL code. I would like see what SQL creates the object dependencies in the
database.
Scott
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of TESTAJ3@xxxxxxxxxxxxxx
Sent: Monday, October 11, 2010 6:05 PM
To: oraracdba; 'oracle-l'
Cc: 'Jared Still'
Subject: Re: Extracting SQL from DBA_SOURCE
U mean like using dbms metadata pkg?
Joe
Sent from the crackberry, so please excuse the typos and terseness.
_____
From: "Scott Heisey" [oraracdba@xxxxxxxxx]
Sent: 10/11/2010 04:22 PM MST
To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
Cc: "'Jared Still'" <jkstill@xxxxxxxxx>
Subject: Extracting SQL from DBA_SOURCE
Has anyone created or know of any code that will extract the SQL from
dba_source? My guess is probably do the complexity of extracting the SQL out of
DBA_SOURCE but thought I would ask anyway.
Scott
Other related posts:
