title: How to create SEQUENCE for GLOBAL TEMPORARY TABLE in oracle?
body: <p>For example</p>
  
  <pre><code>CREATE  GLOBAL TEMPORARY TABLE GGT_temp_reversal 
  (                        
    sessionid  VARCHAR  (50)    NULL,                      
    syspk                    NUMERIC  (23)
  )
  ON COMMIT DELETE ROWS ;
  
  CREATE SEQUENCE GGT_temp_reversal_seq;
  
  CREATE OR REPLACE TRIGGER GGT_temp_reversal_bir 
  BEFORE INSERT ON GGT_temp_reversal 
  FOR EACH ROW
  WHEN (new.id IS NULL)
  BEGIN
    :new.id := GGT_temp_reversal_seq.NEXTVAL;
  END;
  </code></pre>
  
  <p>Getting error "%s: invalid identifier"</p>