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
- 8533 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answer Posted / naresh
A.x=B.x(+) Right Outer Join
(+)A.x=B.x Left Outer Join
A.x=B.x Inner Join
But don't use this type of declaration and declare explicitly
the keyword (Join)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How many categories of data types in oracle?
What are the different types of synonyms?
How to define an oracle sub procedure?
How to get execution statistics reports on query statements?
What are the types of partitions in oracle?
How to start instance with a minimal initialization parameter file?
How to create an oracle testing table?
What are the different editions of oracle?
How to initialize variables with default values?
How do I spool in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to create a stored function in oracle?
what is the use of system.effective.date variable in oracle?
How to execute the package in oracle?
Will you be able to store pictures in the database?explain.
