how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 7873 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 |
How to put more than 1000 values into an oracle in clause?
How to run create database statement?
How to sort output in descending order in oracle?
How to insert multiple rows with one insert statement in oracle?
what is a cartition product?
How to connect the oracle server as sysdba?
what is difference between cartesian join & cross join even they give same result?
What are the differences between date and timestamp in oracle?
What are the most common interview questions on ETL Testing for experience?
In Oracle 10g, "g" Stands for what?
Can a formula column referred to columns in higher group ?
what are the advantages of running a database in NO archive log mode?
Oracle General 
