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

tell me the scenarios of the independent in reports

2403

What is a value set? List its various types.

873

Explain what are the tables of auto invoice?

899

Can you differentiate between mediator and osb?

890

What is the concept of soa governance?

1022

How to move the one file from one instance to another instance? And your scripts also?

871

what is global tempory table?

6788

testing tools?

1982

Can we create tables in apps schema?

877

What is instead of trigger in where we will use?

936

Explain oracle apps architecture.

1032

do you know is it possible to run the interface without using oracle apps?

907

Can u give the Documentation of Custom.pll in oracle apps

3248

Tell me where we find the status of order information?

948

what is pay run id ?

1934