how to make a parameter optional in the query?

Question Posted / anand kumar

Answers were Sorted based on User's Feedback

how to make a parameter optional in the query?..

Answer / ashok

Through NVL function.

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

Is This Answer Correct ?

29 Yes

3 No

how to make a parameter optional in the query?..

Answer / ahmed mazen

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

Is This Answer Correct ?

1 Yes

5 No

More Oracle Apps Technical Interview Questions

We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

can u explain which situation automonus transaction is used

what are the sql attributes?

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

In Per_all_people_f table what is the significance of '_f ' ?

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

In interface how u find errors and how to solve. How to fix it?

What is the link between AP and GL in oracle apps R/12?

what are the different transaction clauses in AR?

What is the autonomous transaction?give me example?

tell me the scenarios of between pages in reports

For more Oracle Apps Technical Interview Questions Click Here