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
Explain the use of constraints option in exp command.
Explain the use of log option in exp command.
In the oracle version 9.3.0.5.0, what does each number shows?
How to drop an existing table in oracle?
How to apply filtering criteria at group level in oracle?
Explain alias?
Is it possible to insert comments into sql statements return in the data model editor ?
What happens to the current transaction if the session is ended?
How to install oracle odbc drivers?
What are the database administrators utilities available?
How to define a data field as not null?
how can we store any pdf file in oracle
Who developed oracle & when?
What are the oracle built-in data types?
How to work with data objects interactively?