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

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

what is the use of anchors?

How can u find custom top? where its located? How to find custom top in front end?

What is the package?

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

What is workflow?Explain with a example?

why we can use synonym?

Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

can we pass bind variablein lexical parameter?

Please let me know the differance between Master Item and organization Item in Inventory.

How do u customize the Reports?

How to generate XML Report with out using rdf?

For more Oracle Apps Technical Interview Questions Click Here