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
- 9858 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answer Posted / hadeera
A.X=B.X(+)
Is left outer join.
It gives all the values of column x table A.
And the values of column X TABLE B of those records which
match the records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are operators in oracle?
How to define a sub function?
Which is faster join or subquery in oracle?
Explain about functional dependency and its relation with table design?
Explain the use of inctype option in exp command.
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain the different normalization forms?
How will you write a query to get a 5th rank student from a table student_report?
What is redo log?
What are the restrictions in a oracle read only transaction?
What is flashback in Oracle?
Is a rollback possible to any savepoint?
What is control file used for?
How many types of database triggers exist?
Name the various constraints used in oracle?
