Re: drop whatever temp;

Damien Salvador wrote:
>
> On Wed, 07 Nov 2001 18:01:37 GMT, Mark Styles
> <news_at_lambic.co.uk> a écrit:
> >On Wed, 07 Nov 2001 18:45:43 +0100, Andreas Koch
> ><mail_at_kochandreas.com> wrote:
> >
> >Seems a bit dangerous, what if another script is running and using
> >it's temp when you try to create yours? Better to create a unique
> >temporary table name.
> >
>
> By the way, is it possible to create triggers on [GLOBAL] TEMPORARY TABLEs ?
>
> --
> Damien

I haven't checked - but if not, you could create a view and use an instead-of trigger on that.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."