title: managing/implementing auto-increment primary key in oracle without triggers
body: <p>We have many tables in our database with autoincrement primary key ids setup the way they are in MySQL since we are in the process of migrating to Oracle from MySQL. </p>
  
  <p>Now in oracle I recently learned that implementing this requires creating a sequence and a trigger on the id field for each such table. We have like 30 -40 tables in our schema and we want to avoid using database triggers in our product, since management of database is out of scope for our software appliance. </p>
  
  <p>What are my options in implementing the auto increment id feature in oracle... apart from manually specifying the id in the code and managing it in the code which would change a lot of existing insert statements.</p>
  
  <p>...  I wonder if there is a way to do this from grails code itself?  (by the way the method of specifying id as increment in domain class mapping doesnt work - only works for mysql)
   Some info about our application environement: grails-groovy, hibernate, oracle,mysql support</p>