We all know what is a "CARTESIAN JOIN", for further reference, pls refer the url mentioned in the references section. I worked on a tuning task of a 11 page report. Two invisible cartesian joins are c...
Apologies to Rogers and Hammerstein; but the title fits. In addition to listening to the scores of old musicals, one of my hobbies is watching the weather. I have about 20 years of weather data in ...
Temporal data support, introduced with Db2 10 for z/OS, is one of the more interesting SQL-related Db2 enhancements delivered in recent releases of the DBMS. Temporal data support comes in two flavors...
Introduction This article series illustrates two ways of doing dynamic SQL, that is, SQL that is programmatically generated and submitted for execution. I have used one of the methods to solve parall...
Tweets, facebook posts and blog posts can be powerfull things. The have the ability to sway peoples opinions of others, to drive people to buy software, to sell stock, and to make bad decissions. Po...
Customize Toad with shortcuts and using templates....
Overview In my last article, Oracle Multi-tenant Application Containers – Part IV, we learned about cross-container aggregation to query user-created data in a metadata-linked table across various app...
Real stories. Real people. Doing real things. With Toad solutions. Cliffhanger Revisited. Recall that in my previous blog post, an IT Director came up to me in Quest’s booth at Oracle OpenWorld l...
We recently released the latest version of Toad Data Modeler (6.3) and I wanted to share with you what’s new. As ever, we make sure we always support the latest database platforms and add new ones w...
One time when I was a little boy, I was driving with my dad and we went over a bridge and there was a sign that read “Weight Limit 10 Tons”. I asked my dad how they figure out how much load the bridg...
In this article, we will learn how to use the Toad for Oracle Editor Window. This tool provides us with a simple editor for working with SQL queries, PL/SQL code and more! This editor is the main int...
