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
- 9003 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 SQL Tuning Advisor in Oracle?
Is it possible to disable the parameter from while running the report ?
20. Using a set operator, display the client number of all clients who have never placed an order.
How do I connect to oracle database?
what is the scripts in data base?
26. Display the earliest shipping date in the format: DD/MON/YYYY
What do you mean by redo log file mirroring?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to drop a tablespace?
How to use like conditions in oracle?
Is a rollback possible to any savepoint?
How would you change old and new values in an insert, delete and update triggers?
Oracle General 
