Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Can a parameter be passed to a cursor?

1053


IS it possible to built the oracle database without setting the kernal parameters?

2272


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1047


What is a database schema in oracle?

1055


What are privileges and grants?

1002


What are oracle functions?

976


What privilege is needed for a user to create tables in oracle?

902


How to delete a user account in oracle?

915


State any two functions of oracle?

984


What is a nvl function? How can it be used?

960


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.

2262


How can we force the database to use the user specified rollback segment?

1069


How to run create database statement?

979


How to find out what oracle odbc drivers are installed?

979


What is background process in Oracle?

1052