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
- 9215 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 are the components of logical database structure in oracle database?
How to count duplicated values in a column in oracle?
What are operators in oracle?
Explain what are the different type of segments?
What is the difference between "as" and "is" in an oracle stored procedure?
How to omit columns with default values in insert statement in oracle?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
What is different bet native dynamic sql and Dbms_Sql?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to assign data of the deleted row to variables?
Explain what are the type of synonyms?
What is the relation of a user account and a schema in oracle?
Oracle General 
