how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 8379 Views
- BOB Technologies, Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / girija.112
ANS:
Only one outer join is possible for a single query & it can be
either left outer join or right outer join or full outer join.
We can't use two outer joins for a single query.
| Is This Answer Correct ? | 17 Yes | 5 No |
Answer / jaya krishna goud
the above answer is valid if we use consider only 2 tables .
Q) How many outer joins we can have for a query considering
more number of tables( eg:5 tables ..?)
Thank U ...
| Is This Answer Correct ? | 0 Yes | 1 No |
What is rich query?
How to upsert (update or insert into a table)?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Compare and contrast between sql and sql server and explain its various functions?
What is set operator oracle?
what is the difference between first normal form & second normal form?
What are the limitations of check constraint?
Explain alias?
Why do we need oracle client?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
How do I find the database name in oracle?
How oracle handles dead locks?
Oracle General 
