A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?

Answer Posted / ramesh

A.x=B.x(+) is not a right outer join it is left outer join

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define and use table alias names in oracle?

505


What are the differences between number and binary_float in oracle?

567


How to empty your oracle recycle bin?

567


How to unlock the sample user account in oracle?

556


What's dateware house and what's clustor with practicle example

1633






Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2452


what happened to the global index when I truncate the data in one of the partition?

1515


How to shutdown your 10g xe server from command line?

554


What is system tablespace?

630


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2058


what is difference between sql plus and sql*plus? (not sql and sql plus).

3342


How to install oracle odbc drivers?

619


Explain the truncate in oracle?

543


Can we create database in oracle using command line ?

581


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1782