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 |
How can windows applications connect to oracle servers?
How to speed up webrick?
How to delete an existing row from a table in oracle?
What are the oracle differences between nvl and coalesce
How to assign values to variables?
create one table to capture an employee details with a primary key.
How to write a query with a right outer join in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How many types of synonyms in Oracle?
What is a nested table?
How do I learn what codesets are available in oracle?
How to write a query with an inner join in oracle?