Re: Why did Oracle change outer joins in ORACLE7?

In article <k520Lc1w165w_at_vicuna.ocunix.on.ca>, frampton_at_vicuna.ocunix.on.ca (Steve Frampton) says:
>
>Hello:
>
>Some of my RPT's don't work anymore under ORACLE7, if they happen to use
>outer joins in selection statements that deal with 'IN' (values_set) or
>'OR' (conditions). This surprised me, and fixing the problem will
>require a less-than-trivial rewrite of the affected reports.
>
>Why would Oracle wish to restrict use of the (+) join operator in this
>fashion? I wanted to get all my employees, in health-benefit policy
>number order...whether they had benefits or not. The way I handled this
>under Oracle V6 was to ask for a benefit(+) in ('DENTAL','VISION',...)
>and then I would get the information I wanted. Now this is impossible.
>:-(
>

I have read something somewhere that explains this but I cannot remember where. When I do I will post it or if I *ever* get my mail working I will send details to you.

Mark Knight Received on Tue May 17 1994 - 17:14:11 CEST