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 a parameter be passed to a cursor?
IS it possible to built the oracle database without setting the kernal parameters?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is a database schema in oracle?
What are privileges and grants?
What are oracle functions?
What privilege is needed for a user to create tables in oracle?
How to delete a user account in oracle?
State any two functions of oracle?
What is a nvl function? How can it be used?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How can we force the database to use the user specified rollback segment?
How to run create database statement?
How to find out what oracle odbc drivers are installed?
What is background process in Oracle?