In the wake of a rise of a variety of so-called NoSQL databases, there’s no doubt that data management has become more complex. But the one surprising thing is how constant the use of SQL has been.

I need to form the equivalent of a Union Join in Oracle 8i, even though a Union Join doesn't appear to be supported in 8i. I might be able to manipulate a Full Outer Join to get the results I need, ...