select * from fnd_user a where (a.user_name = :user_name or :user

how to make a parameter optional in the query?

Question Posted / ahmed mazen

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

Please Help Members By Posting Answers For Below Questions

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2273

tell me the scenarios of the independent in reports

2523

please send me forms, xml pulisher questions,answers

2119

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

2117

In hierarchical structure of a database? we have write query from where we should start?

2256

Can we create tables in apps schema?

1152

what is pay run id ?

2205

What is sca and how is it useful?

1139

Do you know where we can check the status of po?

1299

testing tools?

2264

Do you know what are user profiles in apps. Any examples you can give?

1105

how do you describe O2C along with tables

2783

List the types of flexfield?

1051

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

1117

tell me the scenarios of the independent in reports

2631