Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    India
    Posts
    14

    Unanswered: Temperory tables

    Hi,
    I'm using oracle 8i.How can i create temperory tables?

    Regds
    Manoj

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    insert 'GLOBAL TEMPORARY' into the create table statement.

    PHP Code:
    CREATE GLOBAL TEMPORARY TABLE H_LOADS_TEMP ON COMMIT PRESERVE ROWS
      
    (
      
    ID                NUMBER   (12),
      ....
      ) 
    ON COMMIT PRESERVE ROWS
    You can also use ON COMMIT DELETE ROWS.

    Full discussion of their use is too long to go into here.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •