 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.
 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.) |
|
|
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 (1)
|
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...
|
|
|
Excel and Oracle – 2 Choices for the Query Writer |
|
JeffSmith
|
Thursday, March 06, 2008 1:46 PM
|
|
|
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 ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
A Complete Solution for Oracle DBAs |
|
JeffSmith
|
Monday, January 21, 2008 10:08 AM
|
|
|
|
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 ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Toad for Data Analysis – Tips ‘N’ Tricks |
|
JeffSmith
|
Friday, January 11, 2008 1:41 PM
|
|
|
|
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 ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
|
|
|
|
|
|
|