U mean like using dbms metadata pkg? Joe Sent from the crackberry, so please excuse the typos and terseness. ----- Original Message ----- 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