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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of file param in imp command?

644


What is redo log?

623


Write a trigger example in oracle?

573


how may join possible between (requisition with purchase order)

1699


How to best split csv strings in oracle 9i?

589






Respected sir, Please send me technical questions related to oracle apps..

1379


types of indexes and the rationale behind choosing a particular index for a situation.

1985


How to sort the query output in oracle?

610


How do I limit the number of rows returned by an oracle query after ordering?

636


What are the roles of dba?

614


What are operators in oracle?

532


What are the differences between interval year to month and interval day to second?

553


Give syntax for SQL and ORACLE joins.

634


How do I escape a reserved word in oracle?

630


What do you mean by merge in oracle and how can we merge two tables?

577