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 |
What is query image?
What are the most common interview questions on ETL Testing for experience?
How to select some columns from a table in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
How to convert dates to characters in oracle?
What is the difference between implicit index and explicit index?
What is the relation of a user account and a schema in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is the string concatenation operator in oracle?
what is cartesian product?
what is host string in sql plus? how does it related to database?