2015-05-05

Oracle: ANSI JOIN recommended since 9.2?

Look at this gem I found in the Oracle 9i (!!!) [released in 2001] documentation.

http://docs.oracle.com/cd/B10501_01/server.920/a96540/queries7.htm#2054065
Oracle Corporation 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(...)
Also, http://docs.oracle.com/cd/B10501_01/server.920/a96540/statements_103a.htm#2091953
Oracle Corporation strongly recommends that you use the more flexible Oracle9i FROM clause join syntax shown in the former example.
What is this "FROM clause join syntax"?

It is The ANSI JOIN syntax.

Lol.

No comments :

Post a Comment