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
- 7898 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
what is the difference between request group and request security in oracle apps?
What is oracle soa suite and what are its different components?
Explain oracle apps architecture.
Do you know what is applysys in oracle application database schema, what is apps?
What are the different components of soa suite?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What are the different components you should consider while defining a responsibility in oracle apps?
Do you know where we can check the status of po?
what is global tempory table?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
is it possible to run the interface without using oracle apps?
How is choreography different from orchestration?
What do you understand by soa and what are the benefits of using this architecture?
What are do's and dont's of Interface?
