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 is a nvl function? How can it be used?
What are dml statements in oracle?
State the difference between a primary key and foreign key?
What is meant by recursive hints ?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is the difference between online and offline backups?
How to display row numbers with the records?
What is self-referential integrity constraint ?
Explain about your project and its relation to the current job position you are applying to?
Calculate difference between 2 date / times in oracle sql?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
what is meant by magic query