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
- 8538 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
What are the different windows events activated at runtime ?
Explain integrity constraints?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is Data Dictionary Cache in Oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
When do I need to use a semicolon vs a slash in oracle sql?
How can you merge two tables in oracle?
what are the advantages of running a database in archive log mode?
types of indexes and the rationale behind choosing a particular index for a situation.
What is user managed backup in Oracle?
What happens to the current transaction if a ddl statement is executed?
How to best split csv strings in oracle 9i?
what are steps for interface? where is exchange rate defined in which table?
What happens if you use a wrong connect identifier?
How to update values in a table in oracle?
