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 |
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What are the components of Logical database structure of ORACLE database?
What is flashback in Oracle?
How to use windows user to connect to the server?
waht is the difference between primary key and super key?
how may join possible between (requisition with purchase order)
How do we represent comments in oracle?
How do we know whether an index is created on a table ???
What is a Private Synonyms ?
how to find full database size
1 Answers BirlaSoft, Consultancy,
how to get second highest sal of emp table
What are internal user account in oracle?