Create temporary table in Oracle

Question

I'm trying to create temporary table in PL/SQL developer and insert some data, but it throws error:

ORA-00905

My code:

CREATE PRIVATE TEMPORARY TABLE my_temp_table (
  id           NUMBER,
  description  VARCHAR2(20)
);

Answer 1

CREATE PRIVATE TEMPORARY TABLE introduced only in Oracle 18:

Oracle 18c added private temporary tables, which are single-session in-memory objects.

In previous version, you can create global temporary table:

CREATE GLOBAL TEMPORARY TABLE my_temp_table (
id           NUMBER,
description  VARCHAR2(20)
);