Through NVL function. select * from FND_User a where user

how to make a parameter optional in the query?

Question Posted / ashok

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

List the various types of value set.

1084

What are the Standard Reports and Forms in HRMS?

2320

Tell me how to find the custom directory in front end?

1111

Plz anybody send me Technical specification for AP Interface

2569

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3071

What is instead of trigger in where we will use?

1179

where to define interorganization transaction charges and what are the different options?

2424

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2112

Is soa a part of oracle fusion middleware?

1097

what is the difference between request group and request security in oracle apps?

5906

What do you understand by concurrent programs?

1110

In sequence i want to 11 and 15th values how we will write?

2082

tell me the scenarios of the independent in reports

2626

Can we create tables in apps schema?

1147

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2618