Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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

How do I view a sql database?

0 Answers  


what is External tables? explain with examples

2 Answers   TCS,


explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  


What is structural independence and why is it important?

0 Answers  


use of IN/ANY/ALL

5 Answers   Ramco,






What is oracle sql developer?

0 Answers  


What are different clauses used in sql?

0 Answers  


Does pl/sql support create command?

0 Answers  


Mention what does plv msg allows you to do?

0 Answers  


how to create user in sql and how to set password for that?

3 Answers  


Can you call pl/sql package functions from within a fast formula?

0 Answers  


What has stored procedures in sql?

0 Answers  






Categories