sql oracle create temporary table code example

Example: oracle temporary table

CREATE GLOBAL TEMPORARY TABLE my_temp_table (
    id          NUMBER,
    description VARCHAR2(20)
) ON COMMIT DELETE ROWS;