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
- 7844 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 |
Form development process?
When you run he report you have to get only that particular organization po numbers or item number how can do it?
How will U link GL with OU in Multi-org environment.
Can u define DFF with in the DFF,How?
what are version control tools used in oracle apps?
Difference between set of books id and ledger id in r12 ?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
how will you refer a report column (data column,formula,summery,placeholderr)?
Can u define operating units inplace of inventory?
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
Do you know what is applysys in oracle application database schema, what is apps?
What are Mandatory triggers to write in the block, which is created on view?
Oracle Apps Technical 
