Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vivek
Global Temporary tables are session dependant tables which
could be used as temporary storage for calculations, sorting
etc. What I mean by Session dependant is, the data being
stored in the Global Temporary table is not written into the
database or stored anywhere. Once the session ends (in which
the Global Temporary table is used), the data also vanishes.
However the structure would still be available even after
the Session is logged out. Also, the structure is available
to other sessions even when one session is using it, but not
the data. i.e multiple sessions could use the same Global
Temporary table without interfering the data. Each session
could insert/update/delete their own data into the same
Global Temporary table as if the table is available to only
that session. Any data inserted in one session is not
available to another.
Now, why do we need Global Temporary tables? Well, imagine a
requirement where you need to fetch some data from the
database, do some kind of calculations, aggregations and
provide the Result Set (many records) to a Front End. Again,
in the Front End, you need to fetch the Result set may
times, for some purpose. Then you could make use of the
Global Temporary table. Until the user gets disconnected
from that Database session, the data is available for him in
the memory.
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What are %type and %rowtype for?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What are pl sql data types?
What is the plv (pl/vision) package offers?
describe mysql connection using mysql binary. : Sql dba
Which kind of parameters cannot have a default value in pl sql?
what is 'mysqladmin' in mysql? : Sql dba
Who is the owner of mysql database?
What is Collation Sensitivity ? What are the various type ?
Can procedure in package be overloaded?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is dcl in sql?
what is the difference between truncate and delete statement? : Transact sql
Why partition by is used in sql?
Is it possible to pass parameters to triggers?
