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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Regarding joins what are the differences you observed in
oracle 9i and sql server?

Question Posted / swapna

Answers were Sorted based on User's Feedback



Regarding joins what are the differences you observed in oracle 9i and sql server?..

Answer / 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

Regarding joins what are the differences you observed in oracle 9i and sql server?..

Answer / uma

i have seen in
LEFT JOIN
RIGHT JOIN
INNER JOIN
SELF JOIN

Is This Answer Correct ?    2 Yes 1 No

Regarding joins what are the differences you observed in oracle 9i and sql server?..

Answer / veereshkethari

I'm not happy with Uma answer,anybody can explain?please

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is the use of time stamp in select statement?

1 Answers   TCS,

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

Is sql open source?

0 Answers  

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

What are inner outer left and right joins in sql?

0 Answers  

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

What is pl sql variable?

0 Answers  

What is trigger explain it?

0 Answers  

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 Answers  

What is a pdo connection?

0 Answers  

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

For more SQL PLSQL Interview Questions Click Here
Categories