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
is it possible to run the interface without using oracle apps?
what is the difference between request group and request security in oracle apps?
how can i print random rows in plsql table
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What is oracle soa suite?
In support project one ticket alloted which steps follows manualy tell me ?
Is soa a part of oracle fusion middleware?
What does appl_top directory contain?
What is count(*) from po_vendors(any table)?
What are file in oracle.
Do you know what are user profiles in apps. Any examples you can give?
tell my any difficult situtation you solved in your experience in your company?
In oracle application how do you debug or trace errors?
what is pay run id ?
please send me forms, xml pulisher questions,answers