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

Is grant a ddl statement?

0 Answers  

What are the different sql commands?

0 Answers  

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

Explain commit, rollback and savepoint.

0 Answers  

Explain the rollback statement?

0 Answers  

How we can update the view?

0 Answers  

Can a view be mutating? If yes, then how?

0 Answers  

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

Why we use cross join?

0 Answers  

What is normalization? How many normalization forms are there?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories