Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Is merge a dml statement?

924


How to combine two stored procedures in sql?

1124


what is sql profiler? : Sql dba

997


Why do we use procedures in pl sql?

964


What is sql resultset?

934


Is it possible to link two groups inside a cross products after the cross products group has been created?

955


What is a ddl command?

1008


Why do we use procedures?

914


What is the clause we need to add in function body to return variable?

968


What is dml with example?

1013


Is progress software supports to ( pl/sql )?

973


What is the usage of when clause in trigger?

992


Does postgresql run on the cloud?

1080


Is t sql a programming language?

1007


Can we perform dml in function?

1016