What is the advantage of temporary tables on oracle database?
Anonymous Answered question 05/10/2022
Some of the advantages of temporary tables includes but not limited to:
- For quick data retrieval
- The redo size of temporary tables is less.
- They are visible only to the current session and are dropped automatically when the session is closed.
- Provides better performance
meda Changed status to publish 06/10/2022