Can one connect to Toad for Oracle using ODBC?
NO. Toad for Oracle requires SQL Net client and does a direct connection – end of story. People often ask this question due to a huge misunderstanding about ODBC. They often think that ODBC somehow ...
NO. Toad for Oracle requires SQL Net client and does a direct connection – end of story. People often ask this question due to a huge misunderstanding about ODBC. They often think that ODBC somehow ...
Q: Can you run Toad on an Apple Macintosh? A: Yes. The Toad QA team has been testing Toad on two virtual PC software applications for the Macintosh computer. We are happy to announce that we can offic...
For the second time in as many Toad Data Point (TDP) demos I have had a prospect express interest in the ability to perform a ‘SELECT INTO’ (you may recognize this syntax or something similar dependin...
If you wish to divide large model to multiple workspaces (WS) you have to create new workspace in Toad Data Modeler first and then select objects that should be displayed on the WS. In certain situati...
Wouldn’t it be nice if there was an easy way to free up the time spent performing some of those routine manually-performed DBA tasks? Toad’s Automation Designer helps accomplish this by providing a ha...
A few years ago I wrote a blog titled “Run Toad off a USB Flash Drive”. It’s been a fairly popular blog, but it’s also quite out dated now – so I thought I’d update it. The original blog had several ...
In case you renamed a column and do not want to spend too much time by comparing your model with your database, going through the Sync & Convert Wizard etc., take advantage of simple macro that will p...
One of my favorite features of Toad Data Point is automating complex excel reports. Most reports consist of several sets of data and formatting to make the data attractive or easily readable for the e...
Toad Data Modeler is an extensible software and new features or modifications can be added to the software also via scripts created by users or our dev team. The scripts can be distributed as packages...
Today I want to talk about something that should be beneficial to any person who has ever needed to connect to an Oracle database, comparing data. By that I mean, taking two sets of data and examining...
I don’t know about you but I don’t particularly like dealing with dates in SQL. Unfortunately I don’t seem to be able to avoid them as most of my automated reports deal with a date range. In this post...
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. This post lightl...