cursor duration temporary table - cheeyoung/sqlplus-public GitHub Wiki

5.8 Cursor-Duration Temporary Tables

To materialize the intermediate results of a query, Oracle Database may implicitly create a cursor-duration temporary table in memory during query compilation.