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

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2267


How to rebuild an index in oracle?

990


How to create a table index?

1086


What is SQL Tuning Advisor in Oracle?

1123


What is an oracle table?

941


How a tablespace is related to data files?

1074


What is Java Pool in Oracle?

1110


Can we protect our pl/sql source code?

1007


How to write date and time literals in oracle?

966


How to convert raw data type into text in oracle? Explain

961


What is hot backup and logical backup?

1010


Is it possible to insert comments into sql statements return in the data model editor ?

2521


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2224


How would you go about verifying the network name that the local_listener is currently using?

2007


How will you write a query to get a 5th rank student from a table student_report?

1825