Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98086 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / khaleek
There are three types of joins Equi Join and Non-Equi Join
and Cross Product.
Further Equi join can be divided into following categories...
1) Outer Join
2) Inner Join
3) Self Join
Again Outer join can be divided into following categories..
1) Right Outer Join
2) Left Outer Join
3) Full Outer Join
You can see the detail at..
http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to count groups returned with the group by clause in oracle?
Can we write insert statement in function in oracle?
What happens to the current transaction if the session is killed?
How to create a new tablespace in oracle?
What is procedure overloading in oracle?
How to assign values to data fields in record variables?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Can we call procedure inside function in oracle?
How many types of table in Oracle?
How to create a table interactively?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Can objects of the same schema reside in different tablespace?
Which is faster join or subquery in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
