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 are joins, explain all types of joins?
How to create a new tablespace in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What are the different type of Segments ?
What are the database administrators utilities available?
What are the ways tablespaces can be managed and how do they differ?
What is data file?
how to insert the image in table
What is null value in oracle?
what are the database links ?
What is BBED in Oracle?
How to sort the query output in oracle?