drop global temporary table : Temporary Table « Table « Oracle PL / SQL

drop global temporary table

   
SQL>
SQL> CREATE TABLE employees
  2  ( employee_id          number(10)      not null,
  3    last_name            varchar2(50)      not null,
  4    email                varchar2(30),
  5    hire_date            date,
  6    job_id               varchar2(30),
  7    department_id        number(10),
  8    salary               number(6),
  9    manager_id           number(6)
 10  );

Table created.

SQL>
SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary,department_id ,manager_id)
  2                values ( 1001, 'Lawson', '[email protected]', '01-JAN-2002','MGR', 30000,1 ,1004);

1 row created.

SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary, department_id ,manager_id)
  2                values ( 1002, 'Wells', '[email protected]', '01-JAN-2002', 'DBA', 20000,2, 1005 );

1 row created.

SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary, department_id ,manager_id)
  2                 values( 1003, 'Bliss', '[email protected]', '01-JAN-2002', 'PROG', 24000,3 ,1004);

1 row created.

SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary, department_id, manager_id)
  2                 values( 1004,  'Kyte', '[email protected]', SYSDATE-3650, 'MGR',25000 ,4, 1005);

1 row created.

SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary, department_id, manager_id)
  2                 values( 1005, 'Viper', 'sdillon@a .com', SYSDATE, 'PROG', 20000, 1, 1006);

1 row created.

SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary, department_id,manager_id)
  2                 values( 1006, 'Beck', '[email protected]', SYSDATE, 'PROG', 20000, 2, null);

1 row created.

SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary, department_id, manager_id)
  2                 values( 1007, 'Java', '[email protected]', SYSDATE, 'PROG', 20000, 3, 1006);

1 row created.

SQL>
SQL> insert into employees( employee_id, last_name, email, hire_date, job_id, salary, department_id, manager_id)
  2                 values( 1008, 'Oracle', '[email protected]', SYSDATE, 'DBA', 20000, 4, 1006);

1 row created.

SQL>
SQL> select * from employees;

EMPLOYEE_ID LAST_NAME                                          EMAIL                          HIRE_DATE JOB_ID                         DEPARTMENT_ID     SALARY MANAGER_ID
----------- -------------------------------------------------- ------------------------------ --------- ------------------------------ ------------- ---------- ----------
       1001 Lawson                                             [email protected]                   01-JAN-02 MGR                                        1      30000       1004
       1002 Wells                                              [email protected]                    01-JAN-02 DBA                                        2      20000       1005
       1003 Bliss                                              [email protected]                    01-JAN-02 PROG                                       3      24000       1004
       1004 Kyte                                               [email protected]                    14-JUN-98 MGR                                        4      25000       1005
       1005 Viper                                              sdillon@a .com                 11-JUN-08 PROG                                       1      20000       1006
       1006 Beck                                               [email protected]                   11-JUN-08 PROG                                       2      20000
       1007 Java                                               [email protected]                   11-JUN-08 PROG                                       3      20000       1006
       1008 Oracle                                             [email protected]                  11-JUN-08 DBA                                        4      20000       1006

8 rows selected.

SQL>
SQL>
SQL> create global temporary table session_tab
  2  on commit preserve rows
  3  as select * from employees;

SQL>
SQL>
SQL> drop table session_tab;

Table dropped.

SQL>
SQL>
SQL> drop table employees;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Create temporary table
2.	Create global temporary table from existing table
3.	Create global temporary table with 'on commit delete rows' option
4.	Temporary tables cannot be forced into logging.
5.	Temporary tables support primary keys.
6.	Temporary tables do not support foreign keys
7.	You cannot alter a temporary table to change its data duration.(drop and recreate)
8.	ORA-14452: attempt to create, alter or drop an index on temporary table already in use
9.	Update a TEMPORARY TABLE and check the table it based on
10.	create global temporary table on commit delete rows
11.	Temporary table on commit preserce and delete
12.	Insert into a temporary with select statement
13.	Insert data into the temporary table.
14.	truncate a global temporary table
15.	Using Temporary Tables
16.	Create global temporary table working_emps on commit preserve rows