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
- 9198 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 |
Describe the types of sub query?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
How to select some columns from a table in oracle?
How to use subqueries with the in operator using oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What is Index and different types of Indexes?
Difference between the “verify” and “feedback” command?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Can group functions be used in the order by clause in oracle?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
What are dml statements in oracle?
Query to retrieve record for a many to many relationship ?
Oracle General 
