Create temporary table in Oracle

     Temporary tables are stored in main memory which will be alive until the session expires. We can use like normal tables but these can not be permanent and can't reflect in the memory (Hard-disc).
Syntax:

SQL> CREATE GLOBAL TEMPORARY TABLE marks_tmp
  2  (  std_id     numeric(10)     not null,
  3     std_name   varchar2(50)    not null,
  4     marks      varchar2(50)
  5  )
  6  /
SQL>
SQL>