rem -----------------------------------------------------------------------rem Filename: temptab.sqlrem Purpose: Demonstrate Oracle 8i temporary tablesrem Date: 23-Apr-2000rem Author: Frank Naude, Oracle FAQrem -----------------------------------------------------------------------drop table x/create global temporary table x (a date) on commit delete rows -- Delete rows after commit -- on commit preserve rows -- Delete rows after exit session/select table_name, temporary, durationfrom user_tableswhere table_name = 'X'/insert into x values (sysdate);select * from x;commit;-- Inserted rows are missing after commitselect * from x;http://www.orafaq.com/scripts/sql/temptab.txt