Once again I was reminded how seemingly simple and common-sense features in Toad are frequently overlooked and yet also provide huge differentiation from other database tools out there. If this topic sounds familiar, it’s because I covered it back in 2008 for Toad for Data Analysts.

...

A full preview is in the works, but sometimes a new feature is so compelling you just want to start telling strangers on the street about it right away. Rather than make you wait till tomorrow to hear all about Apple’s new tablet device, here’s some juicy Toad gossip right now!

Toad for Oracle is a world-class enterprise query-develop-tune-administration tool for the Oracle database platform. This document attempts to differentiate Toad from the average Oracle IDE or query tool so that the reader can make an informed decision to invest in the Toad product family.

Following is a list of features and concepts that most commerc ...

Quick, what’s the number one complaint about Toad for Oracle?

“The User Interface is waaaaaaaaay too complicated!”

Out of the box, Toad’s setup to pretty much have everything enabled. If we hid stuff, there’s a good chance users would assume the functionality just wasn’t there to be taken advantage of.&am ...

Oracle introduced support for XML in the relational database going back at least to about the 8i release. Toad for Oracle introduced formal support for XML in the 8.0 release.

So with Toad v10 being released, my Tips & Tricks guide became a bit out of date.  You can find an updated copy, as well as our v9 copy, here.  All of your favorite keyboard shortcuts and workflows rem ...

So if you’re reading this blog, hopefully that means you’ve just finished watching my ‘Discover the Hidden Treasures of Toad for Oracle, Developers’ presentation at our 2009 Toad Virtual Expo. If not, then you can still watch this 45 minute presentation for the immediate 60 days after the conference.

This was a question I got this morning from a customer. I showed them how to do this with the ‘Alter’ dialog in Toad’s Schema Browser. However, they wanted to do it for more than one table at a time, and apparently some OTHER tool could do so. Why couldn’t Toad?

Great question. It turns out that IT CAN INDEED do so. Here’s how:

I think we can all agree that of ALL the features in Toad that impact the most number of users is the data grid. Whether investigating the contents of a table, running queries, or monitoring connected sessions in the Session Browser, the data grids deliver information to the user. How well you know the data grid and all of its embedded features will impact how useful and productive ...

While co-presenting with Bert at the Rocky Mountain Oracle User group, Bert yells out “Hey, show that cool FK lookup thingie in the data grids.” I was like, ‘huh?’ Surely Bert just didn’t call me out in front of 100 or so people on a Toad feature that I did not fully understand?

Well, I got around to figuring out just what Bert was talking about, and NOW I rememb ...

I recently got an email from a user, and after I replied figured that it might be helpful for others to see as well.

 

After working with Toad for almost a decade (I think I first saw it as a new grad in ’99…), I tend to start taking things for granted when I do demonstrations for customers or present at conferences on the beauty of Toad. It’s very easy to get excited about CRUD Matrices and the beauty of PL/SQL debuggers, but overlook the critical core features that users often miss out on.

We often spend a lot of time trumpeting the sexy little widgets in our database tools and overlook the little things that really aid in the development of our applications or even just writing the mundane queries that fill up our day.

I’d like to just spend a quick 10 minutes on letting you know about a cool little feature that Toad for Data Analysis offers for writing your querie ...

So, another version of Toad has been released. It happens a few times a year. If you’re lucky it’s up to you if and when you want to upgrade to get your bug fixes or new features. If you’re in a larger organization, there’s a standards committee that decides who gets what when. I thought I’d spend a few minutes to document what I see to be the key features available in v9.7 t ...

The editor window is probably where most users spend a majority of their time. In this blog, I’ll continue a conversation we had a few weeks ago.  Please note that all of these features are available in the standard edition of Toad for Oracle, version 9.6.

In my previous blog, I covered things that you should know about Toad for Oracle’s editor. I thought for today we could spend a few minutes on what users may benefit the most from Toad’s cousin, Toad for Data Analysis. This blog will concentrate on working with SQL.

The editor window is probably where most users spend a majority of their time. In this blog, I’ll try to highlight the 10 features that will save you the most time when it comes to writing your SQL queries, SQL*Plus scripts, anonymous blocks, and PL/SQL stored procedures. Please note that all of these features are available in the standard edition of Toad for Oracle, version 9.6.

Anyone who develops, supports, or uses PL/SQL at some level also tests the PL/SQL. It may not be a formal testing environment, but there is a time where you will probably ask yourself, “Does this program actually do what it is supposed to?” I think this is something we can all relate to as computer users.
 

This type of testing ...

The Code Insight feature rewrite for version 9.6 is perhaps the most dramatic change as it will affect every Toad user who writes SQL or PL/SQL.
 

In a nutshell, for the 9.6 release, users can now start at the schema level, and use the ‘Dot Lookup’ feature to see all tables, views, synonyms, snapshots, PL/SQL objects etc. You can then dr ...

The Toad World visitors may have noticed a recent surge in the number of videos available for viewing in the past few days.   Toad World will debut a collection of 12 or so Coffee Break Bytes (video tutorials) to highlight the new features for the 9.6 release due out on April 1.
 

I think these videos very nicely compliment

As of April 1, 2008, if you are a current on maintenance and are using at least version 9.6 of Toad for Oracle, you will have complete access to our PL/SQL, Stored Java Source, and SQL*Plus script debugger regardless of your edition of Toad. Since the debugger made its debut in version 6.3 released all the way back in February of 2000, the functionality has been offered as a premium in Toad for Oracle. ...

If you’re a loyal reader, you may remember a blog I published WAAAAAAAY back in July of last year. A few things have changed since then. Users now have 2 different Toad tools to help them get data from Excel merged into the data they already have access to in the Oracle da ...

How often are you offered less work or fewer responsibilities? Rarely does that ever happen, and if it does, it could be a bad sign! Well, as a database administrator, your job gets more and more complex every day even as RDBMS vendors keep adding ‘automated management’ features. On top of all your day-to-day tasks and preventive maintenance you perform, your most ...

One might be tempted to think that with such a young tool like Toad for Data Analysis (TDA), that it would be a bit early to start trumpeting its advanced features and ‘hidden’ productivity boosters. In this case, one would be very wrong! Although Toad for Data Analysis is only up to release 1.1, it is built on top of Toad for SQL Server and Toad for DB2’s award w ...