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
Is there an oracle sql query that aggregates multiple rows into one row?
What happens if recursive calls get out of control?
How to create a testing table in oracle?
How to change system global area (sga) in oracle?
How to drop a stored function?
What is Java Pool in Oracle?
what is Single Byte Overhead...?
How to store only time; not date and time?
IS it possible to built the oracle database without setting the kernal parameters?
What is ordinary table in oracle?
Explain integrity constraints?
what happened to the global index when I truncate the data in one of the partition?
What is the difference between hot backup and cold backup in oracle?
How to create id with auto_increment on oracle?
What is the difference between alert log file and tarce file ?