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

Enlist the data types that can be used in pl/sql?

0 Answers  

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

what is recursive stored procedure? : Sql dba

0 Answers  

Are dml statements autocommit?

0 Answers  

What are reports usually used for?

0 Answers  




When is a declare statement required?

0 Answers  

What is procedure function?

0 Answers  

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

What are some predefined exceptions in pl/sql?

0 Answers  

how to connect oracle in unix prompt?

4 Answers   Polaris,

What is the difference between SQL and PLSQL

4 Answers   IBM,

what is the forward decleration in packages?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories