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


Please Help Members By Posting Answers For Below Questions

How to sort the query output in oracle?

798


What is bulk load in oracle?

811


State and explain the different types of data models?

701


How to change user password in oracle?

797


How to commit the current transaction in oracle?

774


How to define a variable of a specific record type?

839


What is system tablespace?

826


How to declare a local variable?

788


How does Oracle guarantee data integrity of data changes?

2121


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

853


What is the data pump export utility?

832


Oracle

2113


What is a select query statement in oracle?

709


What are the most common interview questions on ETL Testing for experience?

833


How to load data through external tables?

839