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...

various types of joins

Answer Posted / kumar

Types of joins are :

Equi-Join
Non-Equi-Join
Right Outer Join
Left Outer Join
Full Outer Join
Self Join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the restrictions on external table columns?

1054


How to display row numbers with the records?

1080


Is java required for oracle client?

1001


Can we save images in a database and if yes, how?

1065


Can group functions be mixed with non-group selection fields?

1020


How to join two tables in a single query using oracle?

997


What privilege is needed for a user to delete rows from tables in another schema?

1070


Explain the use of inctype option in exp command.

1034


How to pass a parameter to a cursor in oracle?

1184


How to use select statement to count the number of rows in oracle?

1046


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1973


How to add a new column to an existing table in oracle?

1139


Explain mutating triggers.

1031


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1078


what is port in oracle? how is it related to database application.

1949