Re: drop whatever temp;

Andreas Koch wrote:
>
> Hi,
>
> In a script i create a table temp.
> To prevent it failing if some other script created
> a temp and didn't delete it, i use
> drop table temp;
> drop view temp;
> drop trigger temp;
> ....
> before the statement.
>
> Is there a single command to drop temp whatever it is.
> If not, what "types" can temp be? I just added
> "sequence" to my list this morning :)
>
> I guess that's table,view,trigger,procedure and sequence then.
>
> --
> Andreas
> Who doesn't live can never die

Check out 'global temporary tables'. Its very bad news to dynamically create/drop tables in a live systems - its asking for gloom.

hth
connor

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

http://www.oracledba.co.uk

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