A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
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
In what script is snap$ created? In what script is the scott/tiger schema created?
What happens if recursive calls get out of control?
Can group functions be mixed with non-group selection fields?
How to write a left outer join with the where clause in oracle?
Give the advantages and disadvantages of clusters.
What is meant by raw datatype?
What is different types of joins?
What is a trigger oracle?
What are the attributes of the cursor?
How translate command is different from replace?
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.
What is the dynamic sql in oracle?
What to do if dba lost the system password?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to export your connection information to a file?