A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
Answers were Sorted based on User's Feedback
Answer / ramesh
A.x=B.x(+) is not a right outer join it is left outer join
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / surya
A.x = B.x(+) is outer join.
A.x = B.x is inner join of two tables
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / pradeep
A.x = B.x(+) is a left outer join and it will return
all the values of x from A table.
A.x = B.x is a inner join.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / subha
A.x=B.x(+) will display all the vlaues of X from B table
and Deficient information of A table.
IT is right outer join concept.
where as
A.x=B.x will display records that are matching from both
the tables.
Is This Answer Correct ? | 11 Yes | 5 No |
Answer / guest
the difference between A.x=B.x(+) is a outer join and
A.x=B.x is a inner join.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / hadeera
A.X=B.X(+)
Is left outer join.
It gives all the values of column x table A.
And the values of column X TABLE B of those records which
match the records.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naresh
A.x=B.x(+) Right Outer Join
(+)A.x=B.x Left Outer Join
A.x=B.x Inner Join
But don't use this type of declaration and declare explicitly
the keyword (Join)
Is This Answer Correct ? | 0 Yes | 3 No |
What are the various constraints used in oracle?
How to convert dates to characters in oracle?
How to convert characters to times in oracle?
When do we use group by clause in a sql query?
How do we get field detail of a table?
How are the index updates?
Explain enable novalidate constraint.
What is a static data dictionary in oracle?
Explain the difference between replace() and translate() functions in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the quickest way to export a table to a flat file?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,