Re: Global temporary tables v pl/sql tables

From: R Chin <rchin_at_panix.com>
Date: Mon, 8 Jul 2002 09:14:34 -0400
Message-ID: <agc37s$cts$2@reader2.panix.com>

They are different objects...
PL/SQL Table = memory structure, like array, can't use SQL... GTT = real db table that's wriiten to disk, got rowids.... any DML...you know what to do
with ordinary table you kno what to do with GTT. All depends on your needs...you use what you need to do what you want to do.

Robert

Tony Crispin wrote in message ...
>I am looking for a bit of advice/information:
>
>I need to understand the performance implications of using either global
>temporary tables or pl/sql tables for storing temporary data generated
>during a session.
>
>
>How are pl/sql tables implemented by Oracle;
>What is the benefit of using one method rather than the other;
>When should one method be used rather than the other?
>
>Thanks in advance
>Tony
>
>
Received on Mon Jul 08 2002 - 08:14:34 CDT