Regarding joins what are the differences you observed in
oracle 9i and sql server?
Answer Posted / 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 |
Post New Answer View All Answers
Is merge a dml statement?
How to combine two stored procedures in sql?
what is sql profiler? : Sql dba
Why do we use procedures in pl sql?
What is sql resultset?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is a ddl command?
Why do we use procedures?
What is the clause we need to add in function body to return variable?
What is dml with example?
Is progress software supports to ( pl/sql )?
What is the usage of when clause in trigger?
Does postgresql run on the cloud?
Is t sql a programming language?
Can we perform dml in function?