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
Are you familiar with internet architecture of oracle apps 11i?
Tell me how to debug the report?
How do you register report in oracle apps?
What is instead of trigger in where we will use?
how can i print random rows in plsql table
What are the Standard Reports and Forms in HRMS?
Explain oracle apps architecture.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How can you achieve loose coupling in soa framework?
What does appl_top directory contain?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what are the prerequisites for costing transactions?
What are file in oracle.
What is sca and how is it useful?
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