Oracle Global Temporary Table Creation Script

create global temporary table premal
(no number(3)
 name varchar(10))
on commit preserve rows;
or
on commit delete rows;