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

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

1089

List the types of flexfield?

1044

Tell me where we find the status of order information?

1140

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

1980

What is a flexfield? List out its types.

1173

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

1125

what are the different transaction clauses in AR?

2121

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

1111

what is global tempory table?

7213

Can we create tables in apps schema?

1143

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

2664

Tell me how to debug the report?

1125

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

2617

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2219

How do you register report in oracle apps?

1099