Re: returning a constant set of numbers from a "select"

Originally posted by P!
> On Mon, 21 Jul 2003 15:02:53 +0100, "programmer"
> wrote:
>
> >> i cannot guarentee that any tables which will be big enough to
> cover
> >> all of the potential ranges (pot. as large as 20-30k numbers)
> will be
> >> granted to all users of the application, so could use an
> example which
> >> does not rely on tables. i was thinking something along the
> lines of
> >> selecting from a stored procedure - but havnt got a clue how to
> go
> >> about it - any ideas?!
>
>
> same problem as before - it uses a table. I am after a non-table
> based solution ideally.
>
> thanks anyway though,
>
> p!

Tom Kyte has a solution (as always) here:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:227- 0447621346

--
Posted via http://dbforums.com