<snip>
Did the (+) notation used in outer joins "go away" in version 10g?
</snip>
No. But perhaps it should.
The ANSI OUTER join syntax is more readable and now the preferred
method as stated in the Oracle documentation set. See
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/queries00
6.htm#i2054012
where it states:
"Oracle recommends that you use the FROM clause OUTER JOIN syntax
rather than the Oracle join operator. "
More details on why can be found in the link.
Yahoo! Groups TipsDid you know...Want to share photos of your group with the world? Add a group photo to Flickr. |
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
|
||||||||||||||||||||||||||||||
Offline 
Send Email