Simplify the Web

I was working on a query recently in Oracle and couldn't find this answer anywhere on the internet, so I figured I'd put it here for future reference. Joins - Right, Left, Full OUTER Joins in Oracle default to inner if you don't do them right, yep, they don't error, they just default to inner. So if you are trying to get an outer join to work and you are getting less results than you know you should, look for a missing (+). Here's a demonstration: select a.Hello,b.World from first_table a, s...
Read More