how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
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 fastest query method to fetch data from the table?
What is oracle analytical function?
How will you identify oracle database software release?
What are different Oracle database objects?
What is the difference between SQL and SQL Server?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
What is memory advisor in Oracle?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What is indexing, and how does it improve performance?
how to find count rows in table without count function?
What is a trigger and what are its types in oracle?
What are data pump export and import modes?