Have a few (maybe easy) questions about TOAD for DAs (Data Point). Here they are:
- Is there a way to see what the program is executing against the database?
Say, in data compare for example. Is there a session browser that shows what queries are being executed? I’d be interested in having the code from this functionality to execute in the database outside of the TDA GUI.
- Is there a way to extract automation scripts from the GUI?
If say, I create an automated script, does it need to execute from my local machine, triggered by the TOAD GUI or can I export a script that can be stored in the database?
- Same goes for reports (as with automation above)?
If I create a report in the TOAD GUI that I have stored in my project, can I extract this report generation somehow to complete without TOAD, say stored in Oracle as a package or procedure?
Thanks in advance for the help. I guess my questions are generally in regard to how independent what gets created in TDA can become?
I’m trying to determine if this is a tool that requires execution from my local machine (where the Toad DA software is installed) or if it can be used as a tool to help create programs that can be deployed on the remote machine where Oracle is installed (where TOAD is not).