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)

What do you understand by a set of books?

0 Answers  

---

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  

---

Give a overview on Aol

2 Answers   Zensar,

---

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

3 Answers   Wipro,

---

where u do setup of operating unit?

1 Answers   TCS,

---

i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,

---

How to register a form and stored procedure in oracle apps

2 Answers   Mastek, TCS,

---

Can functions be overloaded ?

2 Answers  

---

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,

---

mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,

---

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

---

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---