title: In Oracle, is using Sequences for surrogate primary keys considered standard
body: <p><strong>Caveats:</strong>
  <li>Let me first clarify that this is not a question about whether to use surrogates primary keys or not.</p>
  
  <p><li>Also, this is NOT a related to identities (SQL Server) / Sequences (Oracle) and their pros / cons. I did get a fair bit of idea about that thanks to  <a href="https://stackoverflow.com/questions/1282787/primary-keys-in-oracle-and-sql-server">this</a>, <a href="https://stackoverflow.com/questions/1948644/database-key-id-design-ideas-surrogate-key-primary-key-etc">this</a> and <a href="https://stackoverflow.com/questions/707657/picking-the-best-primary-key-numbering-system/718200">this</a></p>
  
  <p><strong>Question:</strong> </p>
  
  <p>I come from a SQL Server background and have always used identity columns as surrogate primary keys for most tables.</p>
  
  <p>Based on my knowledge of Oracle, I find that the nearest equivalent in Oracle are SEQUENCES which can be used to simulate something similar to Identity in SQL server.</p>
  
  <p><strong><em>As I am new to Oracle and my database has 100+ tables, the main thing that i am concerned about :-</em></strong></p>
  
  <p><li> Considering i have to create a sequence for each table in Oracle (<em>almost</em>), would this be the standard accepted implementation for simulating Identity or is there a better / easier way to achieve this kind of implementation in Oracle?
  <li> Are there any specific GOTCHA's related to having <strong>so many</strong> sequences in Oracle?</p>
  
  <p>The system supports both Oracle 10G and 11G</p>