Interested to Buy Any Domain ? << Click Here >> for more details...
A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
- 7 Answers
- 9658 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
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 is oracle rownum?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
what is difference between DBMS and RDBMS?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
what is normalisation?what are its uses?
What is Virtual Private Database in Oracle?
What is a data lock in oracle?
Can we create trigger on materialized view in oracle?
What is a Data Dictionary ?
Does a Before form trigger fire when the parameter form is suppressed ?
Can we insert data in view oracle?
What a SELECT FOR UPDATE cursor represent.?
Oracle General 
