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
How to start your 10g xe server?
Who developed oracle & when?
What do you understand by a database object?
How to create a stored program unit?
What are the different types of modules in oracle forms?
Hi Can any one tell me what are the API's used in requisition import.
What is SQL Tuning Advisor in Oracle?
What is columnar storage what is the advantage?
What are the set operators union, union all, minus & intersect meant to do?
How to view all columns in an existing table?
Explain an extent?
What are the execution control statements in oracle?
How do I spool in oracle?
What is data file?
What do you understand by a database object? Can you list a few of them?