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 set function in sql .E.g.What is difference between
union and union all

Answers were Sorted based on User's Feedback



What is set function in sql .E.g.What is difference between union and union all..

Answer / durga

set operators are used to combine the out put of more than
one query.

union: used to combine the output Query1 and query2
and display them uniquely

union all : it would combine the two query and displays then
as its duplicates.

Is This Answer Correct ?    10 Yes 0 No

What is set function in sql .E.g.What is difference between union and union all..

Answer / veki

set operators are used to combine the out put of more than
one query.

union: used to combine the output Query1 and query2
and display them uniquely AND OUTPUT IS SORTED
ACCORDING TO FIRST COLUMN OF QUERY1

union all : it would combine the two query and displays then
as its duplicates AND HERE NO SORTING IS DONE.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

in procedure how to return a value

2 Answers   Wipro,


What is a value set? List its various types.

0 Answers  


What are the requests groups?

3 Answers  


what is latest version in reports

8 Answers  


In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,


How do u identity its name of report?

3 Answers  


What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,


Define MultiOrg Structure

5 Answers   Convergys,


What is multoorg and what is it's level or structure

4 Answers   IBM,


In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  


while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,


what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)