Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Types of joins ?

Question Posted / mathur

Answers were Sorted based on User's Feedback



Types of joins ?..

Answer / ramesh yadav

IN ORACLE 9i.

Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join

Non - Equi Join

Outer Join
Left outer join
Right outer joi
Full outer join

Self join
Cartesian Product

Is This Answer Correct ?    9 Yes 0 No

Types of joins ?..

Answer / bipin

sql-server

inner join
outer join
left outer join
right outer join
full outer join
cross join


oracle sql

inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join

Is This Answer Correct ?    8 Yes 2 No

Types of joins ?..

Answer / vinodkumar.r

2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

How will we see framework of a table?

2 Answers   Accenture,

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

What is difference between pls_integer and integer?

0 Answers  

How many types of sql are there?

0 Answers  

Why query optimization is needed?

0 Answers  

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

What is a database event trigger?

0 Answers  

What are the advantages of VIEW?

5 Answers  

How can we debug in PL/SQL?

0 Answers  

What are operators available in sql?

0 Answers  

What are the subsets of sql?

0 Answers  

What is bind reference and how can it be created?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories