Starting 18c, we can create private temporary tables which can be visible to the session that created it using “Create Private temporary table” command.
Following are use cases for private temporary tables
When an application stores temporary data in transient tables that are populated once, read few times, and then dropped at the end of […]