What are joins..how many types of joins are there?
- 29 Answers
- 76611 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
What is analyze command used for?
How to convert numbers to characters in oracle?
How to calculate date and time differences in oracle?
How can we find out the duplicate values in an oracle table?
Explain rename?
What are the differences between primary key and unique key?
How to change program global area (pga) in oracle?
How to install oracle database 10g xe?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to install oracle odbc drivers?
How to create a new view in oracle?
What are the execution control statements?
What is the difference between I and G in Oracle?
What is the difference between substr & instr functions?
What is ceil and floor in oracle?
