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.

Answer / veki

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.

What is the interface?

3 Answers  

---

wht r the basetables of customer interface?

2 Answers  

---

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  

---

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,

---

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

---

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

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

0 Answers   IBM,

---

in procedure how to return a value

3 Answers  

---

Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  

---

why r u transer the data base tables to flat file and what is use

3 Answers   Wipro,

---

What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,

---

do you know is it possible to run the interface without using oracle apps?

0 Answers  

---