I'm working on an Interactive Report which has a WHERE statement like below:
select a, b, c
from table1
where d = :P10_LIST; // this is my selectlist
The column d in the table accepts a string and has 3 possible single values only. E.g: val1, val2, val3.
I'm using Static Values for my Select List with the below values:
Value 1 val1
Value 2 val2
Value 3 val3
All ??? // this is what I'm not sure what to put as value if i wanted to select all records