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
- 2 Answers
- 7952 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 |
What is the maximum number of statements that can be specified in a trigger statement?
What is the reason for distribution hold. Why invoices will go on distribution variance hold ??
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions
what are the mandatory parameters in suppler Conversion?
HOW CAN U KNOW THE STAUS OF PO?
link between po and ap modules
How can u call a standard interface program from sql or pl/sql code?
where is setup of business group done?
how to initialize applications?
What are triggers?
How to register a form and stored procedure in oracle apps
Oracle Apps Technical 
