Enhancement Request: substution variable restriction

[ScottMattes]

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.

 

[Marco Kalter]

I have added this to the list of enhancement requests.