What is set function in sql .E.g.What is difference between
union and union all
Answer Posted / 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 |
Post New Answer View All Answers
What are the Standard Reports and Forms in HRMS?
how can i print random rows in plsql table
In oracle application how do you debug or trace errors?
Do you know what is applysys in oracle application database schema, what is apps?
Plz anybody send me Technical specification for AP Interface
Explain oracle apps architecture.
How can we import the data into a database using sql * loader?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Can you differentiate between mediator and osb?
What are file in oracle.
what are the prerequisites for costing transactions?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Tell me where we find the status of order information?
what are the different transaction clauses in AR?
do you know is it possible to run the interface without using oracle apps?