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?

Answers were Sorted based on User's Feedback



how to make a parameter optional in the query?..

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

how to make a parameter optional in the query?..

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

More Oracle Apps Technical Interview Questions

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,


What is the difference between buyer&employee in PO module?

7 Answers   TCS,


i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,


what do you mean by value sets

8 Answers   Convergys,


Presently u are working in which version?

4 Answers   Accenture,


What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,


what is Flex mode and Confine mode?

2 Answers   Rapidigm,


difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,


what is the use of anchors?

2 Answers   IBM,


What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,


what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,


what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)