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 convert characters to numbers in oracle?
What are the arithmetic operations?
What is a static data dictionary in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Does facebook use oracle?
How to rebuild an index in oracle?
How to manage transaction isolation level?
What is a table index?
what is the dual table in oracle?
What is enter substitution variable in oracle?
How to delete all rows a table in oracle?
How to add a new column to an existing table in oracle?
How do we create privileges in oracle?
What do you mean by a tablespace?
How to concatenate two text values in oracle?