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 objects of the same schema reside in different tablespace?

1043


How many data types are supported?

1065


Why oracle is used?

1033


Please explain compound trigger in oracle?

1033


What is the difference between alert log file and tarce file ?

2148


What are the attributes of cursor?

1029


How to view existing locks on the database?

1028


What is a system tablespace?

1045


What is background process in Oracle?

1078


What the is the diff between local index and global index. give some example.

1616


is there a tool to trace queries, like profiler for sql server?

1128


Explain the use of file option in exp command.

1112


What's dateware house and what's clustor with practicle example

2156


What is oracle datasource?

957


What is the difference between Delete, Truncate and Drop in Oracle?

1104