There can be various reasons why all primary key attributes in your database structure should be named identically. The most typical name is “ID”. But what if you start creating relationships? In Toa...
If you wish to generate localized HTML, RTF or PDF reports, download dictionaries from the following section: Run Toad Data Modeler and click Settings | Dictionaries. New tab Dictionaries opens. Mak...
The email activity in Automation is a very important activity. Most automation scripts end with an email deploying a report or confirmation that the script is complete. To start using Email you ...
As shown in other videos, variables can be very useful in automation. In this video let’s discuss how to use variables with the LoopDataset activity. This activity allows you to take a result set and ...
An Oracle explain plan is very much like a Google map of directions to drive from point-A to point-B (in the old days, before the web, we used to go to a local AAA to get a “Trip Tik” map). However a ...
Scan SQL helps you identify problematic SQL statements in your database environment by automatically extracting statements embedded in database objects, stored in application source code and binary fi...
Not all reports are repetitive. Perhaps you have a situation where you only want to produce a report when a set of circumstances arise. Here is a simple example. Clerks enter orders and at the e...
In Toad for Data Analysts 2.5 Automation Variables were added which greatly expanded what you could accomplish in an automation script. Variables can be used in almost every activity. What is a v...
We are living in the age of windows – I’m in 10 different window app all day long. Very similar I work with my Sql Servers – I have about ten servers and permanently connected to a few of them to exec...
Many Toad Data Point users like to use the Toad Editor. It is very flexible for free handing SQL and scripts. But did you know that you can save your result sets to a file? The file extension for this...
Most automation scripts produce some kind of output, such as an Excel report, and these need to be distributed to end users or storage locations. When there are many such reports you might want to zip...
Toad is never ending story, once started this journey you will never stop learning – there are so many things happening with each release. There is simply no room in documentation for every single ite...
