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
What is the use of file param in imp command?
What is redo log?
Write a trigger example in oracle?
how may join possible between (requisition with purchase order)
How to best split csv strings in oracle 9i?
Respected sir, Please send me technical questions related to oracle apps..
types of indexes and the rationale behind choosing a particular index for a situation.
How to sort the query output in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What are the roles of dba?
What are operators in oracle?
What are the differences between interval year to month and interval day to second?
Give syntax for SQL and ORACLE joins.
How do I escape a reserved word in oracle?
What do you mean by merge in oracle and how can we merge two tables?