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 / 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
Can objects of the same schema reside in different tablespace?
How many data types are supported?
Why oracle is used?
Please explain compound trigger in oracle?
What is the difference between alert log file and tarce file ?
What are the attributes of cursor?
How to view existing locks on the database?
What is a system tablespace?
What is background process in Oracle?
What the is the diff between local index and global index. give some example.
is there a tool to trace queries, like profiler for sql server?
Explain the use of file option in exp command.
What's dateware house and what's clustor with practicle example
What is oracle datasource?
What is the difference between Delete, Truncate and Drop in Oracle?