Transaction-specific temporary tabl

Transaction-specific temporary tables are accessible by user transactions and their child transactions. However, a given transaction-specific temporary table cannot be used concurrently by two transactions in the same session, although it can be used by transactions in different sessions.If a user transaction does an INSERT into the temporary table, then none of its child transactions can use the temporary table afterward.If a child transaction does an INSERT into the temporary table, then at the end of the child transaction, the data associated with the temporary table goes away. After that,either the user transaction or any other child transaction can access the temporary table.