Learn how to efficiently join multiple data sources in a single cross-connection query that returns a single result set using Toad Data Point’s Cross-Connection Query Builder and Editor.
Related Articles
Using Oracle Optimization Hints When Tuning SQL
This tip explains how the Oracle optimization hints are applied to the SQL statements to generate more execution plans in Quest SQL Optimizer for Oracle. One technique that you can use to improve the...
Fixing the “not a valid month” Oracle database error
If you use the DATEdata type in your SQL code, it is likely that you have come across the “not a valid month” Oracle database error. As we shall discuss, the error can be fixed with a slight tweak of ...
Using Toad Data Modeler with Toad Edge for MySQL 5.x – I
Toad Data Modeler and Toad Edge are two tools that complement each other’s functionality very well. Toad Data Modeler provides all the features needed to model data and generate DDL from a model but d...
