Ask a Question
Advertise on boostr.in
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
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
FROM a, b WHERE b.x = a.x
Is there a paragraph I missed?
Â Â Â Â
Sep 9, 2015
to add a comment.
Related Hot Questions
Walkin Jobs Opening
Government Jobs Opening