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 normalization means?
how to fetch alternate records from a table? : Sql dba
What is a trigger word?
Can we use ddl statements in stored procedure sql server?
What is function and procedure?
Can we create table inside stored procedure?
Can we use view in stored procedure?
How delete a row in sql?
How is debugging done?
What are sql constraints?
What is an oracle stored procedure?
What is a memo field?
Can we delete column in sql?
How many primary keys can a table have?
What are procedures used for?