Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.

 |
 |
|
|
 |
 |
|
Author: |
JeffSmith |
Created: |
Monday, July 02, 2007 1:33 PM |
 |
|
Providing information for Toad users that addresses their day to day challenges, with an additional focus on testing (functional and performance/stress.) |
|
It’s the Little Things… |
|
JeffSmith
|
Friday, October 03, 2008 8:00 AM
|
|
|
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 ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Compelling Features for Upgrading to Toad v9.7 |
|
JeffSmith
|
Thursday, September 25, 2008 6:32 AM
|
|
|
|
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 ...
|
 |
|
Comments (1)
|
Read More...
|
|
|
|
|
10 Things You Must Know about Toad’s Editor |
|
JeffSmith
|
Tuesday, July 22, 2008 8:06 AM
|
|
|
|
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.
...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Still Testing Your PL/SQL Manually? STOP-RIGHT-NOW. |
|
JeffSmith
|
Monday, June 30, 2008 7:51 AM
|
|
|
|
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 ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Code Insight in 9.6 – Not seeing your Data Dictionary Views? |
|
JeffSmith
|
Thursday, May 22, 2008 6:48 AM
|
|
|
|
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 ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Need Help Fixing Tables with Duplicate Values? |
|
JeffSmith
|
Thursday, April 24, 2008 7:45 AM
|
|
|
|
Despite the best intentions of the DBA or the person who designed the data model, the collection of primary keys, unique indexes, constraints, and triggers are not a foolproof method of keeping duplicate records creeping into your tables and views. Any business rule in the database can be disabled. An even more likely scenario is the business rule changing after the fact. So ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
Flood of Coffee Break Byte Videos, Thanks Gretchen! |
|
JeffSmith
|
Monday, March 31, 2008 7:22 AM
|
|
|
|
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
 |
|
Comments (0)
|
Read More...
|
|
|
Debugging PL/SQL, now available for everyone! |
|
JeffSmith
|
Tuesday, March 25, 2008 11:25 AM
|
|
|
|
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. ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
 |
 |
|
 |
|
 |
|
|