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 |
waht is the difference between primary key and super key?
How to check the oracle tns settings?
what is query and types of query
What happens if you set the sga too low in oracle?
Which is faster join or subquery in oracle?
what is the exact definition for pointer?
How do I uninstall oracle client from windows?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What are the different types of database objects?
How to get a list of all user accounts in the database?
How to install oracle odbc drivers?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar