how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
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 |
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
what are Triggers?
what is a view?
What is the usage of save points in oracle database?
What are transaction isolation levels supported by oracle?
What is the difference between implicit index and explicit index?
When do you get a .pll extension in oracle? Explain its importance
can a view be updated?
What is a named program unit?
What is the data type of dual table?
Give the constructs of a package, function or a procedure.
What happens if you lost a data file?