title: Finding sequences and triggers associated with an Oracle table
body: <p>I have used this query to fetch the list of sequences belonging to an Oracle database user:</p>
  
  <pre><code>SELECT * FROM all_sequences x,all_tables B
  WHERE x.sequence_owner=B.owner AND B.TABLE_NAME='my_table';
  </code></pre>
  
  <p>But that database user is having many more sequence also, so the query returns me all the sequence of the database user. Can anybody help me to find the particular sequence of <code>my_table</code> using query so that I can get the auto increment id in my application.</p>