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 / 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


Please Help Members By Posting Answers For Below Questions

Are you familiar with internet architecture of oracle apps 11i?

1018


Tell me how to debug the report?

1066


How do you register report in oracle apps?

1033


What is instead of trigger in where we will use?

1128


how can i print random rows in plsql table

2418


What are the Standard Reports and Forms in HRMS?

2230


Explain oracle apps architecture.

1194


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1066


How can you achieve loose coupling in soa framework?

1178


What does appl_top directory contain?

1080


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

3577


what are the prerequisites for costing transactions?

3096


What are file in oracle.

2182


What is sca and how is it useful?

1053


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

2007