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
- 8507 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 |
How to load excel data sheet to oracle database
What is the use of aggregate functions in oracle?
Can a Tablespace hold objects from different Schemes ?
How to use regular expression in pattern match conditions in oracle?
Can we create more than one constraint to column ?
how to truncate date and get only time part 9:20:00
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
What are the different types of failures that occur in Oracle database?
how to see the data (in unix) using dataset in datastage?
Give the advantages and disadvantages of clusters.
Can multiple columns be used in group by in oracle?
how to get second highest sal of emp table
Oracle General 
