Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98049 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth keshavena
Basically join's are three type's those are :
1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.FUll outer join
3.Non-equi join
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the fastest query method to fetch data from the table?
What is varray?
What is the difference between formal parameters and actual parameters?
How can we create the complete backup of data in the oracle.
How to empty your oracle recycle bin?
How to connect asp pages to oracle servers?
How to define and use table alias names in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is an index associated with a constraint?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Is oracle a relational database?
How to resolve name conflicts between variables and columns?
How to view the tablespaces in the current database?
Give syntax for SQL and ORACLE joins.
What is the usage of merge statement?
