| oca doubt [message #539071] |
Wed, 11 January 2012 04:07  |
 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
