Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain oracle apps architecture.

1240


is it possible to run the interface without using oracle apps?

1973


tell me the scenarios of the independent in reports

2619


How can a process be deployed in soa?

1245


What do you understand by soa and what are the benefits of using this architecture?

1073


how can i print random rows in plsql table

2486


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.

3029


tell me the scenarios of the independent in reports

2499


How to move the one file from one instance to another instance? And your scripts also?

1110


what is the difference between request group and request security in oracle apps?

5886


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

3659


What is count(*) from po_vendors(any table)?

1078


Tell me how to debug the report?

1119


q)what are the validations in sql*loader

2397


How do you register report in oracle apps?

1088