Interested to Buy Any Domain ? << Click Here >> for more details...
A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
- 7 Answers
- 9850 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answer Posted / pradeep
A.x = B.x(+) is a left outer join and it will return
all the values of x from A table.
A.x = B.x is a inner join.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do I use unicode codesets with the weblogic jdriver for oracle driver?
State the various uses of dbcc command?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is a trigger and what are its types?
Difference between cartesian join and cross join?
Explain an extent?
definition of cluster and non-clustered index?
Explain rename?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is logical backup in oracle?
How to view all columns in an existing table?
What are joins, explain all types of joins?
What is the difference between pre-select and pre-query?
How do you find current date and time in oracle?
How to check database size in Oracle?
