Regarding joins what are the differences you observed in
oracle 9i and sql server?
- 3 Answers
- 5968 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 |
How do I view a sql database?
what is External tables? explain with examples
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is structural independence and why is it important?
use of IN/ANY/ALL
What is oracle sql developer?
What are different clauses used in sql?
Does pl/sql support create command?
Mention what does plv msg allows you to do?
how to create user in sql and how to set password for that?
Can you call pl/sql package functions from within a fast formula?
What has stored procedures in sql?
-
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 (3303)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
