how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
Answer Posted / 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 |
Post New Answer View All Answers
What are the four Oracle system processes that must always be up and running for the database to be useable?
Is there a combination of "like" and "in" in sql?
Explain the use of record length option in exp command.
What is the difference between $oracle_base and $oracle_home?
What do database buffers contain?
What is a named program unit?
What is a sub query? Describe its types?
What is the max number of columns in an oracle table?
Can group functions be used in the order by clause in oracle?
How many memory layers are in the oracle shared pool?
What is an oracle?
How to write a query with a left outer join in oracle?
How to use "if" statements on multiple conditions?
How to connect to the server with user account: sys?
What is Undo Management Advisor in Oracle?