Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

What is the disadvantage of User defind function?

2340


what are bitmap indexes? How does they work?

2302


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1983


How to define a specific record type?

1136


What is oracle datasource?

1039


What is the data pump export utility?

1130


what is IDE,DMV in sql server?

2878


How to do clean up if create database failed?

1067


How to create lov dynamically at runtime & attach to text field?

1238


State some uses of redo log files?

1064


How to install oracle database 10g xe?

1060


What is the difference between 10g OEM and 11g OEM?

1015


Is oracle a relational database?

966


what is dynamic SGA and static SGA

4486


What are the different types of modules in oracle forms?

1047