GTTS: Global Temporary Tables
Data stored in table to be referred during the session i.e. data in a temporary table is private to the session and purpose can be as follows:
1) Calculation
2) To maintain some data in temp state to process some operation
on commit delete rows
on commit preserve rows till session last
Data stored in table to be referred during the session i.e. data in a temporary table is private to the session and purpose can be as follows:
1) Calculation
2) To maintain some data in temp state to process some operation
on commit delete rows
on commit preserve rows till session last
No comments:
Post a Comment