Home » Other » Training & Certification » oca doubt
oca doubt [message #539071] Wed, 11 January 2012 04:07 Go to next message
artijadhav
Messages: 7
Registered: January 2012
Junior Member
Which two operators can be used in an outer join condition? (Choose two.)
A. =
B. OR
C. IN
D. AND
Ans: D
but while going through oracle docs i came across following..

A full outer join and a partial outer join can be used together in a single SQL statement, but it must in an AND or an AND/OR condition. If a full outer join and partial outer join are used in the OR condition, an unexpected AND condition will result. For example,

SELECT ...
FROM table1 FULL OUTER JOIN table2 ON (A = B or C = D)
is evaluated by Oracle Server as A (+) = B (+) AND C = D.



so....can you help me to figure out the correct answer? and if AND operator can be used can you explain me a little
Re: oca doubt [message #539093 is a reply to message #539071] Wed, 11 January 2012 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OR and IN cannot be used with Oracle outer join (they can be used with ANSI outer join).

Regards
Michel
Re: oca doubt [message #539104 is a reply to message #539093] Wed, 11 January 2012 05:43 Go to previous message
artijadhav
Messages: 7
Registered: January 2012
Junior Member
ok got it...thanks
Previous Topic: oca certification (merged)
Next Topic: OCA certifications (4 threads merged by various)
Goto Forum:
  


Current Time: Thu Mar 28 12:32:04 CDT 2024