Thread: PL/SQL table vs Global Temporary Table

Difference between PL/SQL table and Global Temporary Table.
why we use Global Temporary Table without using PL/SQL Table.

Originally Posted by Sukanta2013

Difference between PL/SQL table and Global Temporary Table.
why we use Global Temporary Table without using PL/SQL Table.

Hello Sukanta,

It's hard to compare these two as the purpose is different ..

Any I am trying best to explain the difference between two

Global Temporary table data is private and inserted on session basis and can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for the whole session, or just for the current transaction.

PL/SQL tables are designed for access with PL/SQL commands. The only access to GTTs is via the SQL engine. You would use GTTs when you want to perform a small number of set-based operations without interleaving PL/SQL commands.

Nested Table Object Types are a kind of hybrid solution. Pretty much the same as PL/SQL tables, but you can also access them with SQL at the overhead of casting the collection to what is effectively a temporary table.

Thanks,
Suji