Обсуждение: temporary table

I want to create a temp table in a trigger... but this must be created max once for each transaction. I'd like to check in the trigger if the table exists. 

A crude way would be to put it in a block and ignore the exception

 BEGIN
        -- create temp table
    EXCEPTION
        WHEN DUPLICATE_TABLE THEN
            -- Table already exists,
            NULL;
    END;

thx
- Amol

Szymon Guz wrote:
> I want to create a temp table in a trigger... but this must be created
> max once for each transaction. I'd like to check in the trigger if the
> table exists.
> How can I check if a table is a temporary table?
>
> regards
> Szymon Guz