What are joins..how many types of joins are there?
- 29 Answers
- 76767 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / tauqueer
Joins means we can join two or more then two table in
single query.
there are 3 types of join..
1. INNER JOIN.
2. OUTER JOIN.
1.Left outer join.
2.right outer join.
3.full outer join.
3. CROSS JOIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to invoke the data pump import utility?
How to drop an existing view in oracle?
Who developed oracle & when?
What is memory advisor in Oracle?
Difference between oracle's plus (+) notation and ansi join notation?
How to estimate disk space needed for an export job?
What happens to the indexes if a table is recovered?
Explain integrity constraints?
What is a nested table and how is it different from a normal table?
Explain the function of optimizer in oracle?
How to assign a table row to a record variable?
How to define an anonymous procedure with variables?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is the sql query to concatenate column values from multiple rows in oracle?
what is Single Byte Overhead...?
