1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Relating to global temporary tables

Discussion in 'SQL PL/SQL' started by Nagaraju, Mar 1, 2011.

  1. Nagaraju

    Nagaraju Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    hi,
    I am nagaraj and i just wan know how exactly the global temp table works and wat is the use of it.

    can anybody explains plz as am new to it.
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    The data in a global temporary table is private, such that data inserted by a session 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. The ON COMMIT DELETE ROWS clause indicates that the data should be deleted at the end of the transaction.

    Check here for Global temporary tables in Oracle
     
    Nagaraju likes this.
  3. Nagaraju

    Nagaraju Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    thnks for the help.