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 are the differences between binary and varbinary? : Sql dba

0 Answers  

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

Explain cursor types?

0 Answers  

Do prepared statements prevent sql injection?

0 Answers  

What is the plv (pl/vision) package offers?

0 Answers  

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

What is cost in sql execution plan?

0 Answers  

What is record type in pl sql?

0 Answers  

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

What is offset and limit in sql?

0 Answers  

How many triggers can be implemented for a table?

3 Answers   HSBC,

For more SQL PLSQL Interview Questions Click Here
Categories