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

>>>>> "dev" == dev <anon_at_anon.com> writes:

 dev> I have tried putting the list in that table but this gets  dev> complicated on a multi-user system using a connection pool.

 dev> Any suggesting on how to handle table clean-up and ensuring that  dev> each user has a table dedicated to them?

 dev> On Fri, 31 Jan 2003 20:21:56 +0100, Sybrand Bakker  dev> <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.
>>

Use temporary global tables for this - each session will only see the records which they have inserted into the table during that session, so multi-user problems just go away! Also, temporary global tables have lots of other advantages because they avoid some of the housekeeping Oracle normally does on normal tables plus they are usually put into a temp tablespace which reduces fragmentation of your main tablespace.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!