Regarding joins what are the differences you observed in
oracle 9i and sql server?
- 3 Answers
- 6587 Views
- Choice Solutions, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siddiq
In oracle joins, there is no need to mention the words like
left outer join, right outer join, etc..
Oracle joins sql joins
-------------------------------------------------
self join Natural join
cross join Arbitary join
outer join Left outer join
Equi join Right outer join
Non Equi join Full outer join
In sql server we have to use the words(join) in the query.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / uma
i have seen in
LEFT JOIN
RIGHT JOIN
INNER JOIN
SELF JOIN
| Is This Answer Correct ? | 2 Yes | 1 No |
I'm not happy with Uma answer,anybody can explain?please
| Is This Answer Correct ? | 0 Yes | 1 No |
What are the types of join and explain each?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
what are the differences among rownum, rank and dense_rank? : Sql dba
what is global table
Why is theta join required?
What is the usage of the distinct keyword?
Can we write dml inside a function in sql server?
Differentiate between pl/sql and sql?
What are three advantages to using sql?
what's the difference between a primary key and a unique key? : Sql dba
what is sub-query? : Transact sql
what is innodb? : Sql dba
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
