3 ms·
> I am confident that anyone who works with Oracle often uses the (+) inside a query to simply force an outer join. For the love of all you hold sacred, please
by drdec 6y ago
> I am confident that anyone who works with Oracle often uses the (+) inside a query to simply force an outer join.
For the love of all you hold sacred, please don't do this.
- miahi 6y agoFor some reason I find a query that uses (+) way easier to read than verbose outer joins. Probably because it's near the field and you see immediately "hey, this can be null". Yes, it makes the query harder to migrate to other DMBS and to collaborate with non-Oracle persons.
- ibejoeb 6y agoTo make it terser, omit `outer` because it is redundant. Now it's up to whatever you find easier to type. Definitely `left` or `right` for me. (+) is a really awkward sequence on QWERTY, at least.