What is set function in sql .E.g.What is difference between
union and union all
- 2 Answers
- 6532 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
how will you refer a report column (data column,formula,summery,placeholderr)?
difference b/w procedures&functions
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
why r u move in the cus_top only why not move another top
In oracle application how do you debug or trace errors?
What is responsibility and how u attach
what is instead of trigger in where u will use?
Oracle E-Business suite?
how to create requst set in oracle apps and how to send muliple requests at a time,
LOCKS?
what is user exit and wat program do we write in user exit?
What is responsibility?
Oracle Apps Technical 
