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

Which type of cursor is used to execute the dml statement?

0 Answers  

define sql update statement ? : Sql dba

0 Answers  

What is record type in pl sql?

0 Answers  

What is the maximum number of columns in sql table?

0 Answers  

What are indexes, and what are the different types?

3 Answers  

explain the difference between bool, tinyint and bit. : Sql dba

0 Answers  

What is data types in sql?

0 Answers  

what is index? : Sql dba

0 Answers  

Can we use having without group by in sql?

0 Answers  

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

What are the query optimization techniques?

0 Answers  

State some properties of relational databases?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories