Create temporary table
SQL> SQL> -- Global Temporary tables SQL> SQL> CREATE GLOBAL TEMPORARY TABLE supplier 2 ( supplier_id numeric(10) not null, 3 supplier_name varchar2(50) not null, 4 contact_name varchar2(50) 5 ) 6 / SQL> SQL> desc supplier; Name Null? Type ----------------------------------------------------------------------------------------------------- -------- -------------------------------------------------------------------- SUPPLIER_ID NOT NULL NUMBER(10) SUPPLIER_NAME NOT NULL VARCHAR2(50) CONTACT_NAME VARCHAR2(50) SQL> SQL> drop table supplier; SQL> SQL>