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 Data File ?
Can you tell me how to add new column in existing views?how?How is possible?
What are Clusters ?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
Why we use bulk collect in oracle?
What is hash cluster in oracle?
13. Display the second to fifth characters in each client name.
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
What is an Index Segment ?
How to rollback the current transaction in oracle?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?