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 / hadeera

A.X=B.X(+)
Is left outer join.
It gives all the values of column x table A.
And the values of column X TABLE B of those records which
match the records.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there an oracle sql query that aggregates multiple rows into one row?

963


What happens if recursive calls get out of control?

1060


How to create a testing table in oracle?

979


How to change system global area (sga) in oracle?

992


How to drop a stored function?

1125


What is Java Pool in Oracle?

1145


what is Single Byte Overhead...?

2537


How to store only time; not date and time?

1005


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

2325


What is ordinary table in oracle?

1132


Explain integrity constraints?

1090


what happened to the global index when I truncate the data in one of the partition?

2009


What is the difference between hot backup and cold backup in oracle?

999


How to create id with auto_increment on oracle?

971


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

2150