RE: Extracting SQL from DBA_SOURCE
- From: "Scott Heisey" <oraracdba@xxxxxxxxx>
- To: <TESTAJ3@xxxxxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Oct 2010 19:39:25 -0700
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:
