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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What are joins..how many types of joins are there?

Question Posted / t.murali krishna

Answer Posted / t.murali krishna

Types of joins:
1. Inner join
equi join
non equi join
selfjoin
2.Outer join
left outer
right outer
full outer(from 9i)
3.Natural join(from 9i)
4.cross join

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2066

How to create a testing table in oracle?

944

What are the common oracle dba tasks?

1068

What is the oracle implicit cursor?

994

What is the use of file param in imp command?

1112

How to define a cusotmer as a supplier in ORACLE R12

2165

Give the advantages and disadvantages of clusters.

993

Explain the difference between sap and oracle?

971

How can I see all tables in oracle?

949

How to display row numbers with the records?

1024

What is oracle database 10g express edition?

1069

How to find the duplicate rows count from employees table in oracle?

1036

Explain what are synonyms used for?

978

How many categories of data types in oracle?

952

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848