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
Can we create tables in apps schema?
Tell me where we find the status of order information?
how can i print random rows in plsql table
What do you understand by concurrent programs?
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
what are the balancing segments in AR?
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.
how to print multi lay outs,muti currency,muti language in xml publisher
What are the benefits of using soa architecture?
testing tools?
What is oracle soa suite?
What is count(*) from po_vendors(any table)?
What is the concept of soa governance?
Can you differentiate between mediator and osb?
Do you know what is applysys in oracle application database schema, what is apps?