Regarding joins what are the differences you observed in
oracle 9i and sql server?
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 |
I need a function for a train ticket reservation please answer it thanks in advance
How many types of privileges are available in sql?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
what are the demerits of sql?
What is the difference between joins?
what eliminate duplicate without using roenum and not
What sql database should I use?
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
Can you create a table with Primary Key not as the clustered index.
How do you create a db file?
What is normalization and types of normalization?
22 Answers Etisbew, F-TEC, Microsoft, TechProcess,
How do I use google cloud in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)