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

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

1926

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

5789

how can i print random rows in plsql table

2412

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2573

What is oracle soa suite?

1177

In support project one ticket alloted which steps follows manualy tell me ?

2611

Is soa a part of oracle fusion middleware?

1034

What does appl_top directory contain?

1075

What is count(*) from po_vendors(any table)?

1034

What are file in oracle.

2179

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

1040

tell my any difficult situtation you solved in your experience in your company?

2282

In oracle application how do you debug or trace errors?

1047

what is pay run id ?

2127

please send me forms, xml pulisher questions,answers

2066