Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,


How to create user and how u attach with responsibility.

2 Answers   Accenture,


WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  


How to print invoice from APPS(front end).if we have invoice number in hand with us???

1 Answers  


what is aim methodolozy

1 Answers   Wipro,






oracle apps architecture

1 Answers   TCS,


How to develop XML report without rdf?

4 Answers   Oracle,


do you know is it possible to run the interface without using oracle apps?

0 Answers  


in one report using two layout models.if yes how to do

4 Answers   Covansys,


what is latest version in reports

8 Answers  


In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,


How to link between inventory and OrderManagement.

1 Answers   Zensar,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • 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)