How can I use Toad for Oracle to extract SQL Statements from a package or procedure and do the following things with it?
1) Execute the statement
2) Optimize the staement
3) User the statement in the Query Builder
Here is a video tutorial showing how to extract SQL statements:
Here is a link to the video:
http://www.quest.com/tv/All-Videos/1254993539001/How-to-Extract-SQL-Statements-with-Toad-for-Oracle/Video/
