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


Please Help Members By Posting Answers For Below Questions

Can I create users through internet explorer in oracle 10g?

765


List out the components of logical database structure of oracle database.

780


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2300


How many types of tables supported by oracle?

770


What are the limitations of check constraint?

758


Explain view?

780


How many types of tables are there in oracle?

792


How to start your 10g xe server?

769


How to change program global area (pga) in oracle?

820


How can we view last record added to a table?

787


What is the maximum limit on the number of columns in a table?

739


How are extents allocated to a segment?

769


How to get last row id?

729


What is ASM (Automatic Storage Management) in Oracle?

879


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1922