tag:blogger.com,1999:blog-7395977411859619892.post4948085606394176670..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: EXISTSRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7395977411859619892.post-67253211177581262562011-09-29T22:55:51.963+02:002011-09-29T22:55:51.963+02:00Rafu, thanks for the addition. Much like a where c...Rafu, thanks for the addition. Much like a where clause in old style join syntax. But probably with some subtle differences in outer joins. I'm struggling with a practical use case. Do you know one?Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-84727079336374174912011-09-27T14:38:20.792+02:002011-09-27T14:38:20.792+02:00EXISTS can be used also on a join condition. But b...EXISTS can be used also on a join condition. But be aware if you use <a href="http://rafudb.blogspot.com/2011/09/migrating-to-11203-ora-00976.html" rel="nofollow">a hierarchical query there and are going to 11.2.0.3</a>Rafuhttps://www.blogger.com/profile/09149025430133739471noreply@blogger.com