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 / ramesh
A.x=B.x(+) is not a right outer join it is left outer join
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How to create a stored procedure in oracle?
What is SQL access advisor in Oracle?
How would you go about verifying the network name that the local_listener is currently using?
What is BBED in Oracle?
How to use "startup" command to start default instance?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to assign data of the deleted row to variables?
What are the various constraints used in oracle?
Describe varray?
What is an index associated with a constraint?
Can we use bind variables in oracle stored procedure?
How to view the tablespaces in the current database?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain the types of exception?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?