Oracle's (+) syntax does not allow for full outer joins. The conclusion would be the same with Oracle's syntax. It's just more obscure, as it would turn into a

Oracle's (+) syntax does not allow for full outer joins. The conclusion would be the same with Oracle's syntax. It's just more obscure, as it would turn into a "fa.film_id < 10" vs "fa.film_id(+) < 10" discussion.