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
q)what are the validations in sql*loader
What is a value set? List its various types.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
tell me the scenarios of the independent in reports
can we get profile values in report without using user exists is it possible how?
How to move the one file from one instance to another instance? And your scripts also?
Explain oracle apps architecture.
What is count(*) from po_vendors(any table)?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What do you understand by soa?
Tell me how to find the custom directory in front end?
Are you familiar with internet architecture of oracle apps 11i?
Explain what are the tables of auto invoice?
what are the balancing segments in AR?