Just loving the flexibility of input variables (now that I found that chapter 12 applies to the SQL Window as well as reports)!
I would like to be able to restrict an input to a range of values for the variable type. Where this came up was
&<name="priority" type="integer" default="99">,
the valid values here would be 1-99.
So, if there isn't some method that is not intuitively obvious to this casual observer, could we have a "range" keyword?
Thank you.
O,just thought of
select rownum
from all_objects
where rownum < 100
Still, I think that range would be a good addition.