how to make a parameter optional in the query?
Answer Posted / ashok
Through NVL function.
select * from FND_User a
where user_name = nvl(:User_Name, a.user_name)
Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
What are the different components you should consider while defining a responsibility in oracle apps?
is it possible to run the interface without using oracle apps?
Tell me how to debug the report?
Are you familiar with internet architecture of oracle apps 11i?
How do you register report in oracle apps?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
tell my any difficult situtation you solved in your experience in your company?
what is the difference between request group and request security in oracle apps?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
what are the different transaction clauses in AR?
List the various types of value set.
In support project one ticket alloted which steps follows manualy tell me ?
tell me the scenarios of the independent in reports
how to print multi lay outs,muti currency,muti language in xml publisher
What do you understand by concurrent programs?