Query related to Global Temporary Table

Tags:
Oracle
Oracle Tables
PL/SQL
When should we use a GTT and When should we use a collection?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

This question would require a long blog post to be answered correctly.

It all depends on the amount of data you plan to manipulate and the kind of manipulation you want to do with it.

If you plan to load millions of rows, for example, you would be better off using a GTT, because doing it with collections on a multi-user system would be a little risky because of the amount of memory it would require.

Also, if you need the power of SQL to be available to you, you would also need to go with GTTs.

On the other hand, if you need to use data types that are only allowed in PL/SQL, such as boolean, for example, you would have to use collections.

There are many things to consider, so, without more details, a single correct answer cannot be provided.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: