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
- 2 Answers
- 8022 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 |
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
can we get profile values in report without using user exists is it possible how?
what is back order in OM
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
what is the defference between credit memo and debit memo
What do you understand by soa?
In oracle application how do you debug or trace errors?
what are the different calculation columns available in reports?
How You Will display the key flexifields in your report
what are the error tables in AP?
Can anybody tell me, What is the Implementation Process?
is it possible to run the interface without using oracle apps?
Oracle Apps Technical 
