Interested to Buy Any Domain ? << Click Here >> for more details...
how to make a parameter optional in the query?
- 2 Answers
- 9253 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
where u do setup of operating unit?
Explain what are the tables of auto invoice?
Tell me some thing about SQL-LOADER.
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
where is chandra institute in hyderabad for oracle apps technical training ?
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
what are the sql attributes?
how to call report from oracle oracle apps11i?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
What is the use of format trigger?
Is that Possible To create package without Specification , If Yes Give any Examples
how can u find the status in po?
Oracle Apps Technical 
