Re: Extracting SQL from DBA_SOURCE
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: TESTAJ3@xxxxxxxxxxxxxx
- Date: Tue, 12 Oct 2010 07:44:09 -0700
Also consider dynamic SQL. The SQL statement does not actually exist until
run time, so there is no way you could ever find it in the pl/sql code.
On Tue, Oct 12, 2010 at 4:10 AM, <TESTAJ3@xxxxxxxxxxxxxx> wrote:
> 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.
>
> ------------------------------
>
> * 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:
