Question: why we need gtt in oracle?
Answer: Enhancing security and privacy: In sensitive businesses, GTT is invaluable because it only saves data for the session and the same cannot be queried by other users. Quicker data retrieval: During a session, you can store your data in a tabular form in the temporary table and access it instantly when you need it.