Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL - long list in the where clause. Any ideas?
On 01 Feb 2003, noodles_at_aol.com wrote:
> Correct me if I'm wrong but wouldn't the 9i feature of an external
> table be a solution ? If I remember correctly, then you can manage
> your where clause with a logical table on the file system.
Its not that you can't do it this way, but there seems to be lots of issues that you would have to tackle that the database is already tackling for you.
My first big question for this solution is, what if more than one session is doing the same thing? How do you handle concurrent access to the file that the external table is reading?
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Sun Feb 02 2003 - 22:00:13 CST