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
- 9014 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 |
Can you tell me how to add new column in existing views?how?How is possible?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
How many anonymous blocks can be defined?
How to check the oracle tns settings?
What is a procedure in oracle?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What is a deadlock ? Explain .
How can you use check constraints for self referential integrity?
Explain 1st, 2nd, 3rd normalization form of data base
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
Find all employees in Dept “Marketing”.
Explain the function of optimizer in oracle?
Oracle General 
