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
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to rebuild an index in oracle?
How to create a table index?
What is SQL Tuning Advisor in Oracle?
What is an oracle table?
How a tablespace is related to data files?
What is Java Pool in Oracle?
Can we protect our pl/sql source code?
How to write date and time literals in oracle?
How to convert raw data type into text in oracle? Explain
What is hot backup and logical backup?
Is it possible to insert comments into sql statements return in the data model editor ?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How would you go about verifying the network name that the local_listener is currently using?
How will you write a query to get a 5th rank student from a table student_report?