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

What normalization means?

968


how to fetch alternate records from a table? : Sql dba

1106


What is a trigger word?

1018


Can we use ddl statements in stored procedure sql server?

1006


What is function and procedure?

1025


Can we create table inside stored procedure?

949


Can we use view in stored procedure?

892


How delete a row in sql?

990


How is debugging done?

967


What are sql constraints?

1172


What is an oracle stored procedure?

1048


What is a memo field?

963


Can we delete column in sql?

1089


How many primary keys can a table have?

1005


What are procedures used for?

983