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 / 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 |
Post New Answer View All Answers
What are the various constraints used in oracle?
What are the parameters that we can pass through a stored procedure?
How do we get field details of a table?
How to store pictures on to the database?
State the difference between a primary key and foreign key?
How do I find my oracle client driver version?
What are the benefits of ordbms?
How to manage transaction isolation level?
List out the types of joins.
Explain the importance of .pll extension in oracle?
How to connect ms access to oracle servers?
What is snapshot is too old? Give and example for better understand.
Difference between inner join vs where ?
What is an oracle cursor variable?
What are the common oracle dba tasks?