What are joins..how many types of joins are there?
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 do you understand by database schema and what does it hold?
How to divide query output into groups in oracle?
How to update values on multiple rows in oracle?
How to use select statement to count the number of rows in oracle?
How to convert dates to characters in oracle?
How to use in conditions in oracle?
How to return top 5 rows in oracle?
How does oracle handle read consistency?
How to create a testing table in oracle?
How to define and use table alias names in oracle?
How to convert characters to times in oracle?
Give the different types of rollback segments.
How can you use check constraints for self referential integrity?
How do I find the database name in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.