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
- 10079 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 to use subqueries with the exists operator in oracle?
What is clustered table in Oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to download oracle database 10g xe?
Where is the export dump file located?
Can objects of the same schema reside in different tablespace?
What is enter substitution variable in oracle?
What is proxy method?
How to create id with auto_increment on oracle?
How to view existing locks on the database?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What happens if variable names collide with table/column names?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Which is better Oracle or MS SQL? Why?
