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

From: Alan Mills <Alan.Mills_at_xservices.pants.fujitsu.com>
Date: Mon, 21 Jul 2003 15:04:48 +0100
Message-ID: <bfgrv6$1oag$1@news.icl.se>

"p!" <p!@unix.ndo.co.uk> wrote in message news:3f1bed32.17401140_at_news...
> On Mon, 21 Jul 2003 14:20:15 +0100, "Alan Mills"
> <Alan.Mills_at_xservices.pants.fujitsu.com> wrote:
>
> >
> >"p!" <p!@unix.ndo.co.uk> wrote in message news:3f1be5ed.15540453_at_news...
> >> hi,
> >>
> >> could anyone tell me how i can do the following:
> >>
>
> <snip>
>
> Try that.
> >
> >
>
> thanks for the quick reply Alan.
>
> 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,

oh, I don't know. A bundle of the system tables and views can be pretty big. ALL_TAB_COLUMNS for example. UNION ALL with itself a couple of times should do the trick. I'm sure you dcould come up with something. Received on Mon Jul 21 2003 - 09:04:48 CDT