how to make a parameter optional in the query?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create tables in apps schema?

851


Tell me where we find the status of order information?

932


how can i print random rows in plsql table

2150


What do you understand by concurrent programs?

810


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2128


what are the balancing segments in AR?

1857


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2761


how to print multi lay outs,muti currency,muti language in xml publisher

11522


What are the benefits of using soa architecture?

922


testing tools?

1971


What is oracle soa suite?

978


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

834


What is the concept of soa governance?

1001


Can you differentiate between mediator and osb?

863


Do you know what is applysys in oracle application database schema, what is apps?

958