how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 8523 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 |
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How many memory layers are in the shared pool?
What is bulk collect in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is a subquery?
What is using clause and give example?
how may join possible between (requisition with purchase order)
How to update values in a table in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Explain an index segment?
How is it different from a normal table?
what is difference between foreign key and reference key
Oracle General 
