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

Form development process?

1 Answers  


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  


what is the use of placeholer column?

3 Answers  


pls send me out bound code of supplers,site,bankiformation code pls as soon as

0 Answers  


How to create a purchase order without a requisition?

0 Answers  






What is count(*) from po_vendors(any table)?

0 Answers  


how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,


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

0 Answers  


Types of cursors?

3 Answers  


What is a flexfield? List out its types.

0 Answers  


In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,


How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  


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