Learning about Oracle JOIN types, etc.

Bud — Mon, 13 Jun 2022 13:21:08 GMT

As a non-DBA/developer, I’ve always found resources about SQL joins to be clunky.

I came across a resource recently that I found helpful: https://oracle-base.com/articles/misc/sql-for-beginners-joins

One thing I like about that list is: it accounts for join name synonyms (variations in join names) via the words in brackets.
Another thing I like: the list of join types is actually complete (unlike most join lists). For example, it includes information about CROSS JOIN LATERAL in the Additional Joins link, which is a join type that’s often overlooked (use case here).

In general, I really like oracle-base.com. It’s much better than the Oracle docs, which seems to be missing a lot of key information, are hard to read, and out-of-date. And seem to be meant for people who are already experts on the content. Whereas oracle-base.com is the opposite of all those things.

Many people will already know about that resource, but some might not, so I thought I’d share.

Cheers.

topic Learning about Oracle JOIN types, etc. in ArcGIS Enterprise Questions

Learning about Oracle JOIN types, etc.