how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 8110 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 |
Where do we use decode and case statements?
which language is used to develop the oracle........?
query optmization techniques and quwry analyser+projects+ppts
What is the difference between Sleep and Wait? (Java)
How to retrieve data from an explicit cursor?
What is max rowid in oracle?
How to write a query with a full outer join in oracle?
How to convert times to characters in oracle?
Explain the use of online redo log files in oracle.
What is oracle database 10g express edition?
What is the Tune Query
What are the Limitations of a CHECK Constraint ?
Oracle General 
