Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96978 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / reshma patil
when you want to retrive data from two or more tables then
you require joins.
Types of joins:-
1)Cross join/Cartain join
2)Equi join/inner join
3)Outer join
4)Self join
5)Non-equi join
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of oracle?
What happens in oracle commit?
What are the differences between lov and list item?
What are the different windows events activated at runtime ?
Why does oracle 9i treat an empty string as null?
Why does Oracle not permit the use of PCTUSED with indexes?
How to define a data source name (dsn) in odbc manager?
How to define a record variable to store a table row?
What are the major difference between truncate and delete?
How can I get column names from a table in oracle?
What is the difference between $oracle_base and $oracle_home?
Please explain oracle data types with examples?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Does oracle partitioning improve performance?
Is it possible to insert comments into sql statements return in the data model editor ?
