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
- 7896 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 |
why do we validate the records while developing interface?
What are the requests groups?
Tell me some interface tables on ordermangement.
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.
in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?
what are the functions you are used in utl_file at the time of transferring the data?
what is the prerequisite for defining unit of measure?
what is the difference between %_all and %_f tables
what is the defference between credit memo and debit memo
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
Plz anybody send me Technical specification for AP Interface
Do you know what are user profiles in apps. Any examples you can give?
Oracle Apps Technical 
