What is set function in sql .E.g.What is difference between
union and union all
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?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
what is the use of placeholer column?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
How to create a purchase order without a requisition?
What is count(*) from po_vendors(any table)?
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
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
Types of cursors?
What is a flexfield? List out its types.
In support project one ticket alloted which steps follows manualy tell me ?
How many parameters we can pass through pl/sql program in Oracle apps