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 / ramesh
A.x=B.x(+) is not a right outer join it is left outer join
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the different types of modules in oracle forms?
What is null value in oracle?
How do you bind variables in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What are the differences between blob and clob in oracle?
What is hot backup and logical backup?
How to call a sub procedure?
How to use "in" parameter properly?
What is Redo Log Buffer in Oracle?
Is a rollback possible to any savepoint?
How to download oracle database 10g xe?
How to write text literals in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Explain the dml?
How do you find current date and time in oracle?