Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL - long list in the where clause. Any ideas?

Re: SQL - long list in the where clause. Any ideas?

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Fri, 31 Jan 2003 21:10:07 GMT
Message-ID: <PCB_9.16863$ni5.3047736@news1.news.adelphia.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US