Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


is there an oracle official recommendation on the use of explicit ansi joins vs


is there an oracle official recommendation on the use of explicit ansi joins vs  using -'oracle,join'

Note: I am not asking you to tell me “use explicit joins” but looking for Oracle official position if any on that subject.

From Oracle database documentation (also appears in 9i and 11g documentations):


  Oracle recommends that you use the FROM clause OUTER JOIN syntax
  rather than the Oracle join operator. Outer join queries that use the
  Oracle join operator (+) are subject to the following rules and
  restrictions […]


In other words, Oracle advises to prefer the first of these two forms:

FROM a LEFT JOIN b ON b.x = a.x
vs
FROM a, b WHERE b.x(+) = a.x


However, I have never found in any Oracle documentation a single recommendation to use preferably one of those two forms:

FROM a INNER JOIN b ON b.x = a.x
vs
FROM a, b WHERE b.x = a.x


Is there a paragraph I missed?
    

asked Sep 9, 2015 by RocUKT
0 votes
8 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...