how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 7877 Views
- BOB Technologies, Cap Gemini, IBM, I also Faced
- E-Mail Answers
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 is an oracle tablespace?
How to call a stored function in oracle?
How do I spool to a csv formatted file using sqlplus?
What is the difference between substr and instr?
Is java required for oracle client?
How to omit columns with default values in insert statement in oracle?
How can I introduce multiple conditions in like operator?
State some uses of redo log files?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to list all user accounts in oracle?
How to write a query with a left outer join in oracle?
How many file formats are supported to export data?
What is a data lock in oracle?
What is a user role in oracle?
Explain implicit cursor.
