A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
Answer Posted / 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 |
Post New Answer View All Answers
How to bring a tablespace online?
How to grant create session privilege to a user in oracle?
What is a trigger and what are its types?
How to start instance with a minimal initialization parameter file?
How to get the Installed Oracle Version Information ?
How to download oracle database 10g xe?
What does sharding mean?
Is there a function to split a string in plsql?
Does oracle database need java?
What are the extensions used by oracle reports?
How to export your own schema?
How can you use check constraints for self referential integrity?
What are the restrictions on external table columns?
How to convert characters to times in oracle?
Can we call procedure inside function in oracle?