how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
Answer Posted / 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 |
Post New Answer View All Answers
How to sort the query output in oracle?
What is bulk load in oracle?
State and explain the different types of data models?
How to change user password in oracle?
How to commit the current transaction in oracle?
How to define a variable of a specific record type?
What is system tablespace?
How to declare a local variable?
How does Oracle guarantee data integrity of data changes?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is the data pump export utility?
Oracle
What is a select query statement in oracle?
What are the most common interview questions on ETL Testing for experience?
How to load data through external tables?