oracle

CREATE OR REPLACE TRIGGER  "ERA_PREFERENCES_TIG"  
    before insert on "ERA_PREFERENCES"                
    for each row   
  begin    
      select "ERA_PREFERENCES_SEQ".nextval into :NEW.ID from dual;  
  end; 
   
  ALTER TRIGGER  "ERA_PREFERENCES_TIG" ENABLE

CREATE SEQUENCE   "ERA_ PREFERENCES_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 120 CACHE 20 NOORDER  NOCYCLE