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
Explain oracle apps architecture.
is it possible to run the interface without using oracle apps?
tell me the scenarios of the independent in reports
How can a process be deployed in soa?
What do you understand by soa and what are the benefits of using this architecture?
how can i print random rows in plsql table
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.
tell me the scenarios of the independent in reports
How to move the one file from one instance to another instance? And your scripts also?
what is the difference between request group and request security in oracle apps?
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 is count(*) from po_vendors(any table)?
Tell me how to debug the report?
q)what are the validations in sql*loader
How do you register report in oracle apps?