Re: Append resultset

If you are running Oracle 8.1, then

    create global temporary table - with session based lifetime;     create unique index on {the global temporary table}

The definition is global, but each user gets their own segments, and the Uniqueness applies only to their segment.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

buurd_at_my-deja.com wrote in message <81b6hi$n60$1_at_nnrp1.deja.com>...
> Hi!
>I have to make several queries to solve a problem but there is a small
>catch. I want the results from each and every query to append the same
>resultset. One way I can think of is creating a temporary table but the
>problem is that table must be uniqe for this run. The next user who
>might run the same query at the same time must not use the same
>temporary table.
>My problem is that i don't know how to make this temporary table
>threadsafe (as it would be called in Java) so the other user don't
>interfer with the first user. Or is there another way so solve this
>problem. The queryies will run as a function returning a column from
>the temporary table.
>
>Tia
>--
>Roland Carlsson
>Certified Java programmer
>Skövde
>Sweden
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Nov 22 1999 - 13:47:21 CST