create temporary table sql oracle code example

Example: oracle temporary table

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