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
- 9856 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answer Posted / subha
A.x=B.x(+) will display all the vlaues of X from B table
and Deficient information of A table.
IT is right outer join concept.
where as
A.x=B.x will display records that are matching from both
the tables.
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
What is oracle rowcount?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What are data pump export and import modes?
How to convert characters to times in oracle?
How to filter out duplications in the returning rows using oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are the attributes that are found in a cursor?
How to delete a user account in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
Is truncate autocommit in oracle?
What is a dynamic performance view in oracle?
How to drop a tablespace?
What is the difference between primary key and unique key and foreign key in oracle?
What do you mean by redo log file mirroring?
