Oracle Reports (MOSC)

MOSC Banner

LOV Default

edited Aug 10, 2012 3:23AM in Oracle Reports (MOSC) 2 commentsAnswered ✓

How does a default Oracle report parameter work? 

Let's say you have a table that has a status with values blank, A, B, and C and the parameter is the status.

The query would be select status from table where status = <parm>.  If the parameter isn't entered, statuses blank, A, B. and C should be displayed.

How do I ensure that I get this result set, when the parameter isn't entered:

select status from table where status in (blank,A,B,C)

and not this result set:

select status from what where status IS NULL
 

Thanks.  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center