Apr 222013
create global temporary table  
      contains_data_that_is (
    varchar2(1)  default 'Y',
    varchar2(50) default 'removed on commit',
) on commit preserve rows;

I've always found the "global" naming of temporary tables slightly confusing, 
as this implies the data is visible across all sessions. 
I guess it could be to distinguish these from SQL server temporary tables, 
which can be created on the fly in a single session.
If you know better, please enlighten me in the comments!

For a demo of temporary tables in action, use this.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>