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...

what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .

Answer Posted / amretha

For set operators the columns in the tables must be the same.Where as for Joins if one column is same its enough to join two or more tables.

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

 How to use an oracle sequence generator in a mapping?

1025


Explain the difference between replace() and translate() functions in oracle?

979


Briefly explain what is literal? Give an example where it can be used?

980


What are the attributes of cursor?

995


How to create a new table in your schema?

1038


How to open a cursor variable?

981


Can you assign multiple query result rows to a variable?

935


How to convert numbers to characters in oracle?

976


What do you mean by group by clause?

990


What are the limitations of check constraint?

971


How to create tables for odbc connection testing?

1022


How to write text literals in oracle?

1026


What types of joins are used in writing subqueries?

943


Which is better Oracle or MS SQL? Why?

6271


What is set verify off in oracle?

1037