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 / naresh
A.x=B.x(+) Right Outer Join
(+)A.x=B.x Left Outer Join
A.x=B.x Inner Join
But don't use this type of declaration and declare explicitly
the keyword (Join)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain the difference between sap and oracle?
How to convert raw data type into text in oracle? Explain
What is a trigger oracle?
What is define in oracle?
How would you go about verifying the network name that the local_listener is currently using?
What is oracle database 10g express edition?
What do you know about normalization? Explain in detail?
Whats the benefit of dbms_stats over analyze?
How to store pictures on to the database?
What is ADDM Advisor in Oracle?
What are the different types of trigger and explain its various uses and functions?
What is the usage of control file in oracle?
How to load a large xml file?
What happens if recursive calls get out of control?
How do we represent comments in oracle?