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

In what script is snap$ created? In what script is the scott/tiger schema created?

2656


What happens if recursive calls get out of control?

1000


Can group functions be mixed with non-group selection fields?

963


How to write a left outer join with the where clause in oracle?

1027


Give the advantages and disadvantages of clusters.

997


What is meant by raw datatype?

1005


What is different types of joins?

969


What is a trigger oracle?

1038


What are the attributes of the cursor?

936


How translate command is different from replace?

1009


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2134


What is the dynamic sql in oracle?

1008


What to do if dba lost the system password?

1091


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2220


How to export your connection information to a file?

1076