Answer / ashok

Through NVL function.

select * from FND_User a
where user_name = nvl(:User_Name, a.user_name)

Answer / ahmed mazen

select * from fnd_user a
where (a.user_name = :user_name or :user_name is null)

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

---

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

---

what do you mean by value sets

8 Answers   Convergys,

---

Presently u are working in which version?

4 Answers   Accenture,

---

What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,

---

what is the use of anchors?

2 Answers   IBM,

---

What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,

---

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

---

what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  

---