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

Can we group by two columns in sql?

0 Answers  

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

Why procedure is used in sql?

0 Answers  

what are ddl statements in mysql? : Sql dba

0 Answers  

how to include comments in sql statements? : Sql dba

0 Answers  

Explain the working of foreign key?

0 Answers  

what is the difference between sql and t-sql? : Transact sql

0 Answers  

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

Why do we use set serveroutput on?

0 Answers  

what happens if null values are involved in expressions? : Sql dba

0 Answers  

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories