What are joins..how many types of joins are there?
Answer Posted / shree
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
| Is This Answer Correct ? | 47 Yes | 16 No |
Post New Answer View All Answers
How to drop an index?
What do you mean by a deadlock?
How do I uninstall oracle 11g?
What is bulk copy or bcp in oracle?
How to best split csv strings in oracle 9i?
What is bind variable in oracle 11g?
How to loop through a cursor variable?
How to run queries on external tables?
How to lock and unlock a user account in oracle?
How to call a sub procedure?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
State and explain the different types of data models?
Compare and contrast between sql and sql server and explain its various functions?
Who developed oracle & when?
Difference between varchar and varchar2 data types?