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
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is the cause of mutating table error and how can we solve it?
What is spool?
What are the types of dbms?
how many columns can be used for creating index? : Sql dba
How do you write an inner join query?
Which one is better subquery or joins?
how to use regular expression in pattern match conditions? : Sql dba
What are views in sql?
How is use pl and sql?
Can 2 queries be executed simultaneously in a distributed database system?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Can we create foreign key without primary key?
What is not in sql?
Explain some predefined exceptions.