What are joins..how many types of joins are there?
Answer Posted / m.sivakumar
joins is a that combines the rows from two or more tables
joins are 5 types
1.cross join
2.equi join or inner join
3.outer join
4.self join
5.non_equi join
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain joins in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How do I call oracle stored procedures that take no parameters?
How to lock and unlock a user account in oracle?
How to assign values to variables?
How to use fetch statement in a loop?
What are the different pseudo commands? Explain in general?
How do I manually uninstall oracle client?
How do we get field details of a table?
Explain how are indexes update?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to export your own schema?
How to use "in" parameter properly?
What is an oracle database table?
is there a tool to trace queries, like profiler for sql server?