how to make a parameter optional in the query?

Question Posted / anand kumar

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

More Oracle Apps Technical Interview Questions

Where we can write a PL/SQL code in report triggers?

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

What is ment by Global Templates in Oracle.

differentiate between intra & inter UOM class conversion with examples.

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

what is flexfield qualifier?

What is responsibility?

what is the difference between procedure and function

what are the difference between oracle discoverer and report6i

what is organization id

HOW CAN U KNOW THE STAUS OF PO?

What is oracle soa suite and what are its different components?

For more Oracle Apps Technical Interview Questions Click Here