how to make a parameter optional in the query?
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 |
What r the validation types?
Tell me some errors names and number what u got while developing the reports?
what is inbound and outbound interface?
In unix Schell sript what is very 1st line to be wriiten .
What are file in oracle.
where we can check the status of po.
In xml report, how to print the headings in every page?
How can we import the data into a database using sql * loader?
What are the files we submit while your program move to testing instance?
Cycle of requestion to receving transaction.
What is oracle soa suite and what are its different components?
Can you define an erp system?