5 ms·
Curious about the below, what happens on Oracle? >>> Pay attention to any left joins. If a column from a left join is used in a where or select clause it might
by aidos 8y ago
Curious about the below, what happens on Oracle?
>>> Pay attention to any left joins. If a column from a left join is used in a where or select clause it might be null.
- irrational 8y agoIt's a side effect of empty strings and nulls being different on Postgres, but not on Oracle.
- aidos 8y agoOh really? You’d get empty strings for every column in the outer joined table?