Re: temp table

Cupofjava1961 wrote:

> Can someone tell me why the global keyword is used when creating
> a temporary table?
>
> such as in:
>
> create global temporary table my_temp_tab
> as select * from my_tab ;
>
> Thanks

To indicate, as I understand it, that the table is for global use, by all sessions, rather than being session specific.

Remember GTTs are not temporary tables at all. The tables are permanent ... it is the data that is temporary.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)