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
- 9852 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
What is a trigger oracle?
Explain how are indexes update?
Difference between inner join vs where ?
What is the usage of control file in oracle?
How to convert characters to dates in oracle?
Explain alias?
What is hash cluster in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to get a list of all user accounts in the database?
List out the types of joins.
Explain temporal data types in oracle
What is key preserved table?
how to join query for one source type is oracle another source type is sql server ?
How oracle handles dead locks?
