Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

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>