Join are used to connect two or more tables. There are 3 types of joins.

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

Question Posted / suresh

Answer Posted / suresh

Join are used to connect two or more tables. There are 3
types of joins. 1) Inner Join 2) Outer Join 3) Self Join

Is This Answer Correct ?

57 Yes

31 No

Please Help Members By Posting Answers For Below Questions

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2002

How do I know if oracle is installed on windows?

928

Difference between pre-select and pre-query

1101

Can we insert data in view oracle?

1014

What is merge in oracle?

1052

What is coalesce function?

1067

What is program global area (pga) in oracle?

1025

how can we store any pdf file in oracle

2161

Can multiple columns be used in group by in oracle?

983

How many anonymous blocks can be defined?

1181

How to use an explicit cursor without open statements?

1051

How to change program global area (pga) in oracle?

1084

Where do we use decode and case statements?

1011

How to omit columns with default values in insert statement in oracle?

1044

What is bind variable in oracle 11g?

1037