Toad World® Forums

Script used in Toad background to get results?

I am curious if there is a way to see what the script is that Toad uses to get results. An example would be when you select Database -> Administor -> Audit SQL/SysPrivs. What is the query that Toad is running in the background to get the results?

This is just one example. It would be nice to know how to see any script that Toad uses to get information.

The reason I would like to know what is happening is so I can get the script and tweek it some to give me a little more, or different information from the views/tables that Toad is accessing.

From the main menu: Database -> Spool SQL -> Spool SQL to Screen.

While that is turned on, any sql executed in Toad is spooled to the bottom of the screen.