Interested to Buy Any Domain ? << Click Here >> for more details...
Regarding joins what are the differences you observed in
oracle 9i and sql server?
- 3 Answers
- 8341 Views
- Choice Solutions, I also Faced
- E-Mail Answers
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 meaning of <> in sql?
How delete a row in sql?
Why we use pl sql?
Can function return multiple values in sql?
What is the difference between database trigger and stored procedure?
What is pl sql in oracle?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
what is primary key? : Sql dba
What are the types of subqueries?
what is an index? : Sql dba
What is the usage of distinct keyword?
How can I make sql query run faster?
Can we rollback delete command?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is latest version of sql?
