Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL - long list in the where clause. Any ideas?
How about one table with a userid field?
"dev" <anon_at_anon.com> wrote in message
news:3e3ad5b5.940892000_at_news-east.newscene.com...
> I have tried putting the list in that table but this gets complicated
> on a multi-user system using a connection pool.
>
> Any suggesting on how to handle table clean-up and ensuring that each
> user has a table dedicated to them?
>
> On Fri, 31 Jan 2003 20:21:56 +0100, Sybrand Bakker
> <gooiditweg_at_nospam.demon.nl> wrote:
>
> >On 31 Jan 2003 13:06:59 -0600, anon_at_anon.com (dev) wrote:
> >
> >>Does anyone know of a better way to accompish this?
> >
> >Put the list in a table.
> >
> >
> >Sybrand Bakker, Senior Oracle DBA
> >
> >To reply remove -verwijderdit from my e-mail address
>
Received on Fri Jan 31 2003 - 15:10:07 CST