Oracle 18c introduced, Private temporary tables concept which are temporary database objects that are dropped at the end of a transaction or session. Private temporary tables are stored in memory and each one is visible only to the session that created it.
The “CREATE PRIVATE TEMPORARY TABLE” statement to create a private temporary table. The ON COMMIT clause indicates if the data in the table is transaction-specific (the default) or session-specific.
Here is my explanation on Oracle Live SQL.
This statement creates a private temporary table that is transaction specific: Continue reading → Oracle 18c – Private Temporary Tables