Forum OpenACS Q&A: Response to Bugtraq: ansi outer join syntax in Oracle 9i allows access to any data

Yes, Sebastiano, that's a complete list of restrictions, I believe.  In particular the last one (restrictions on outer joins when more than one table's being joined) has bitten me more than once.

I'm not fond of the silent errors that can arise from not using (+) consistently.

And of course the old Oracle syntax doesn't support full outer joins.

Nor does it support outer joins using complex expressions rather than simple columns.

We don't use the last two in OpenACS but once we move to Oracle 9i we might (hard to use something that doesn't exist in your supported version, and thus far we support 8i not 9i).