Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

q)what are the validations in sql*loader

2411


What is a value set? List its various types.

1102


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

2222


tell me the scenarios of the independent in reports

2626


can we get profile values in report without using user exists is it possible how?

2887


How to move the one file from one instance to another instance? And your scripts also?

1132


Explain oracle apps architecture.

1259


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

1089


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

2048


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?

1069


What do you understand by soa?

1162


Tell me how to find the custom directory in front end?

1111


Are you familiar with internet architecture of oracle apps 11i?

1070


Explain what are the tables of auto invoice?

1142


what are the balancing segments in AR?

2101