Re: AND, OR can not be used in an outer join condition?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 28 Nov 2000 20:46:28 -0000
Message-ID: <975440619.23647.0.nnrp-09.9e984b29@news.demon.co.uk>

Where did you get the question and the 'answer' ? The correct answer is (b) and (d). Not surprisingly, since Oracle often translates an IN into an OR anyway.

Look up error ORA-01719:
"out join operator (+) not allowed in operand of OR or IN"

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



gmei_at_my-deja.com wrote in message <8vv8kl$sds$1_at_nnrp1.deja.com>...


>Hi:

>

>I am trying to understand the following question:

>

>Q: Which two operators can not be used in an outer join condition?

>

>a. =

>b. IN

>c. AND

>d. OR

>

>Answer is c and d.

>

>I understand "=" can be used in an outer join condition. Could some one

>give examples of how to use "IN" in outer join and what kind of error

>"AND" and "OR" would generate in an outer join condition?

>

>Thanks.

>

>Guang

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Tue Nov 28 2000 - 14:46:28 CST