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
- 9195 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 |
What is the difference between SQL and SQL Server?
What is the difference between 10g OEM and 11g OEM?
How to sort output in descending order in oracle?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
How to define an oracle sub procedure?
What is format trigger?
Please explain drop constraint oracle?
What is a initialization parameter file in oracle?
What is hot backup and logical backup?
How to convert dates to characters in oracle?
How to bring a tablespace offline?
What is the function of Redo Log ?
Oracle General 
