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.
About the Author
Julie Hyman is a Director of Product Management at Quest Software with over 20 years of experience in software development, technical support, and product management.
Related Articles
Oracle System Global Area (SGA) – Overview
SGA refers to a Shared Global Area. As the term global implies, this area is accessible to all Oracle processes and users. Each instance will have its own SGA. Oracle processes and users must share la...
Managing Containers and Pluggable Databases
Hi, Oracle12 introduced a new database architecture for the Oracle database: multi-tenant or pluggable databases. The basic concept is a container database (CDB) that can contain one or more pluggabl...
Why Some SQL Tuning Rewrites are not always Correct ?
A junior developer came to me recently and asked me a SQL transformation question. He gave me an example of a SQL statement similar to this one: select * from TableA A where A.KeyCol/10 = 12345 The p...
