Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Outer join Operator(+) with operand of OR or IN (Oracle, 11g, Windows 7)
Oracle Outer join Operator(+) with operand of OR or IN [message #659569] Mon, 23 January 2017 00:19 Go to next message
azamkhan
Messages: 555
Registered: August 2005
Senior Member
Hello,

I want to use outer join operator and Or operand. My query is as follows:

Select *
From
a,
b,
c,
d, --|__> Both are same tables. But need different values.
f --|
Where a.a = b.a
And a.c = a.c
And ( (d.e = 'Value' And SubStr(d.g(+), 5, 10) = a.a)
Or
(f.e= 'Value' And SubStr(f.g(+), 1, 7) = a.c)
);

In the query table "D" and "F" represent same table, but to get different values I have to take them as separate tables.

I know that Oracle does n't allow to use "OR" operand with Outer Join (+). So I was wondering if there is any other alternate logic to do this.
Re: Oracle Outer join Operator(+) with operand of OR or IN [message #659570 is a reply to message #659569] Mon, 23 January 2017 00:22 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use ANSI syntax: LEFT/RIGHT OUTER JOIN and not Oracle syntax (+).

Previous Topic: Effective Date/Min Eff Seq subquery issues
Next Topic: Edition Based Redefinition - Triggers on Editioning Views
Goto Forum:
  


Current Time: Wed Jan 17 05:59:47 CST 2018

Total time taken to generate the page: 0.01177 seconds