Interested to Buy Any Domain ? << Click Here >> for more details...
how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 9040 Views
- BOB Technologies, Cap Gemini, IBM, I also Faced
- E-Mail Answers
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 |
Who developed oracle & when?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
material view and view disadvantages?
What are the attributes of the cursor?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
What is recovery manager in Oracle?
How to define and use table alias names in oracle?
How to loop through a cursor variable?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How can windows applications connect to oracle servers?
How do I connect to oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Oracle General 
